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