studentschema.sql
· 1.2 KiB · MySQL
Raw
-- Personal Information
first_name VARCHAR NOT NULL,
last_name VARCHAR NOT NULL,
birth_date DATE NOT NULL,
sex VARCHAR NOT NULL,
-- Account / Login
email VARCHAR NOT NULL UNIQUE,
password VARCHAR NOT NULL,
username VARCHAR, -- Required if not using same account
use_same_account BOOLEAN DEFAULT FALSE,
token VARCHAR NOT NULL,
-- Location & Contact
country_id INTEGER NOT NULL,
country_iso VARCHAR(2) NOT NULL,
state_id INTEGER NOT NULL,
municipality_id INTEGER NOT NULL,
neighborhood_id INTEGER,
phone_code INTEGER NOT NULL,
phone_number VARCHAR NOT NULL,
-- Academic / School
instance_name VARCHAR NOT NULL,
grade_id VARCHAR NOT NULL,
school_name VARCHAR, -- Required if instance is not 'ucv'
school_key VARCHAR, -- Required if instance is not 'ucv'
account_manager_id VARCHAR NOT NULL,
-- Identification
national_id_type VARCHAR NOT NULL, -- e.g., 'CURP', 'DNI', 'OTHER'
national_id VARCHAR NOT NULL,
document_id INTEGER NOT NULL,
-- Legal & Consent
terms BOOLEAN NOT NULL CHECK (terms = TRUE),
consent BOOLEAN NOT NULL CHECK (consent = TRUE),
consent_form_id VARCHAR NOT NULL,
consent_provider VARCHAR NOT NULL
| 1 | |
| 2 | -- Personal Information |
| 3 | first_name VARCHAR NOT NULL, |
| 4 | last_name VARCHAR NOT NULL, |
| 5 | birth_date DATE NOT NULL, |
| 6 | sex VARCHAR NOT NULL, |
| 7 | |
| 8 | -- Account / Login |
| 9 | email VARCHAR NOT NULL UNIQUE, |
| 10 | password VARCHAR NOT NULL, |
| 11 | username VARCHAR, -- Required if not using same account |
| 12 | use_same_account BOOLEAN DEFAULT FALSE, |
| 13 | token VARCHAR NOT NULL, |
| 14 | |
| 15 | -- Location & Contact |
| 16 | country_id INTEGER NOT NULL, |
| 17 | country_iso VARCHAR(2) NOT NULL, |
| 18 | state_id INTEGER NOT NULL, |
| 19 | municipality_id INTEGER NOT NULL, |
| 20 | neighborhood_id INTEGER, |
| 21 | phone_code INTEGER NOT NULL, |
| 22 | phone_number VARCHAR NOT NULL, |
| 23 | |
| 24 | -- Academic / School |
| 25 | instance_name VARCHAR NOT NULL, |
| 26 | grade_id VARCHAR NOT NULL, |
| 27 | school_name VARCHAR, -- Required if instance is not 'ucv' |
| 28 | school_key VARCHAR, -- Required if instance is not 'ucv' |
| 29 | account_manager_id VARCHAR NOT NULL, |
| 30 | |
| 31 | -- Identification |
| 32 | national_id_type VARCHAR NOT NULL, -- e.g., 'CURP', 'DNI', 'OTHER' |
| 33 | national_id VARCHAR NOT NULL, |
| 34 | document_id INTEGER NOT NULL, |
| 35 | |
| 36 | -- Legal & Consent |
| 37 | terms BOOLEAN NOT NULL CHECK (terms = TRUE), |
| 38 | consent BOOLEAN NOT NULL CHECK (consent = TRUE), |
| 39 | consent_form_id VARCHAR NOT NULL, |
| 40 | consent_provider VARCHAR NOT NULL |
| 41 |