formacao_superior.sql

/*
Copyright (C) 2016 Centro de Computacao Cientifica e Software Livre
Departamento de Informatica - Universidade Federal do Parana - C3SL/UFPR

This file is part of HOTMapper.

HOTMapper is free software: you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation, either version 3 of the License, or
(at your option) any later version.

HOTMapper is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with HOTMapper.  If not, see <https://www.gnu.org/licenses/>.
*/

-- Docentes: Tabela de CURSOS DE FORMAÇÃO SUPERIOR
CREATE TABLE formacao_superior
(
    id INT NOT NULL,
    -- Código Área	--
    area_cod	    TINYINT,
    --Nome Área --
    area_nome	    VARCHAR(50),
    -- Código OCDE	--
    curso_cod	    VARCHAR(6) NOT NULL,
    -- Nome - Grau	--
    curso	        VARCHAR(100),
    -- Grau Acadêmico --
    grau_academico	VARCHAR(20),

    CONSTRAINT formacao_superior_pk_id PRIMARY KEY (id)
);