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)