Änderungen von studentschema.sql

1 file changed, 40 insertions

studentschema.sql(Datei erstellt)

		@@ -0,0 +1,40 @@
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

Neuer Älter