hwDB3
Tables (5)
Applicant (Untitled)
- Applicant_id (Key) — Bigint — Primary key — NOT NULL
- name (Field) — varchar(100)
- resident_number (Field2) — varchar(20)
- email (Field3) — carchar(100)
- call_number (Field4) — varchar(20)
- phone_number (Field5) — varchar(20)
- address (Field6) — varchar(255)
- pax_number (Field7) — varchar(100)
Applicant_info (Untitled2)
- Applicant_id (Key) — Bigint — Foreign key → Applicant.Applicant_id — NOT NULL
- highest_education (Field) — varchar(100)
- is_married (Field2) — boolean
- religion (Field3) — enum
- height (Field4) — decimal(5,2)
- weight (Field5) — decimal(5,2)
- blood_type (Field6) — enum
- vision (Field7) — varchar(10)
- hobby (Field8) — varchar(50)
- speciality (Field9) — varchar(50)
Family (Untitled3)
- family_id (Key) — bigint — Primary key — NOT NULL
- Applicant_id (Key2) — Bigint — Foreign key → Applicant.Applicant_id — NOT NULL
- relationship (Field) — varchar(50)
- name (Field2) — varchar(100)
- age (Field3) — int
- highest_education (Field4) — varchar(100)
- occupation (Field5) — varchar(100)
- residence (Field6) — boolean
FamilyRelation (Untitled5)
- Applicant_id (Key) — Bigint — Foreign key → Applicant.Applicant_id — NOT NULL
- relation_type (Field) — varchar(100)
- family_name (Field2) — varchar(10)
education (Untitled4)
- education_id (Key) — bigint — Primary key — NOT NULL
- Applicant_id (Key2) — Bigint — Foreign key → Applicant.Applicant_id — NOT NULL
- start_date (Field) — datetime(0)
- end_date (Field2) — datetime(0)
- school_name (Field3) — varchar(100)
- major (Field4) — varchar(100)