scholarshipDB

Tables (3)

ScholarshipInfo (Untitled3)

  • id (Key) — INT — Primary key
  • title (Field) — VARCHAR(20)
  • date (Field2) — DATE — NOT NULL
  • url (Field3) — VARCHAR(50)
  • content (Field4) — VARCHAR(100)
  • Field5

UserCondition (Untitled)

  • userId (Key) — VARCHAR(20) — Primary key
  • income (Field) — INT — NOT NULL
  • parent (Field2) — VARCHAR(5) — NOT NULL
  • children_all (Field3) — INT — NOT NULL
  • children_me (Field4) — INT — NOT NULL
  • preScore (Field5) — FLOAT — NOT NULL
  • preGrade (Field6) — INT — NOT NULL
  • semester (Field7) — INT — NOT NULL
  • highArea (Field8) — VARCHAR(20) — NOT NULL
  • highCategory (Field9) — VARCHAR(20) — NOT NULL
  • area (Field10) — VARCHAR(30) — NOT NULL
  • attending (Field11) — BOOLEAN — NOT NULL
  • country (Field12) — VARCHAR(10)
  • nationalMerit (Field13) — BOOLEAN — NOT NULL
  • disabled (Field14) — BOOLEAN — NOT NULL

UserInfo (Untitled2)

  • email (Field3) — VARCHAR(20)
  • id (Field) — VARCHAR(20)
  • pw (Field2) — VARCHAR(20)