Local Social Course

Tables (6)

CLASS (Untitled4)

  • classId (Key) — int(1000) — Primary key — NOT NULL
  • name (Field) — char(30)
  • level (Field2) — char(2)
  • year (Field3) — int(4)
  • month (Field4) — int(2)
  • lecturer (Field5) — char(10)
  • fee (Field6) — int(6)
  • providerId (Key2) — int(100) — Foreign key → SERVICEPROVIDER.providerId — NOT NULL
  • subjectId (Key3) — int(10) — Foreign key → SUBJECT.subjectId — NOT NULL

CLIENT (Untitled)

  • clientId (Key) — int(5) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(100)
  • phone (Field3) — int(11)
  • email (Field4) — char(100)

DEPENDANT (Untitled2)

  • dependantId (Key) — int(5) — Primary key — NOT NULL
  • name (Field) — char(10)
  • phone (Field2) — int(11)
  • clientId (Key2) — int(5) — Foreign key → CLIENT.clientId — NOT NULL

ENROLL (Untitled3)

  • clientId (Key) — int(5) — Foreign key → CLIENT.clientId — NOT NULL
  • classId (Key2) — int(1000) — Foreign key → CLASS.classId — NOT NULL
  • grdae (Field) — char(2)
  • review (Field2) — LONGTEXT
  • Field3

SERVICEPROVIDER (Untitled5)

  • providerId (Key) — int(100) — Primary key — NOT NULL
  • name (Field) — char(100)
  • address (Field2) — char(100)
  • phone (Field3) — int(12)
  • grade (Field4) — float(3)
  • memo (Field5) — LONGTEXT
  • type (Field6) — char(4)

SUBJECT (Untitled6)

  • subjectId (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(30)
  • memo (Field2) — LONGTEXT