exercise 3번
테이블 (9)
CLIENT (Untitled)
- client id (Key) — int(5) — 기본 키 — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(100)
- phone (Field3) — int(11)
- email (Field4) — char(100)
DEPENDANT (Untitled2)
- dependantid (Key) — int(5) — 기본 키 — NOT NULL
- name (Field) — char(10)
- phone (Field2) — int(11)
- client id (Key2) — int(5) — 외래 키 → CLIENT.client id — NOT NULL
ENROLL (Untitled3)
- ID (Key) — 기본 키 — NOT NULL
- grade (Field) — char(2)
- review (Field2) — LONGTEXT
- date (Field3) — date
- Field4
- client id (Key2) — int(5) — 외래 키 → CLIENT.client id — NOT NULL
- serviceid (Key3) — int(1000) — 외래 키 → SERVICE.serviceid — NOT NULL
MANAGER (Untitled9)
- managerid (Key) — int(100) — 기본 키 — NOT NULL
- name (Field) — char(20)
- phone (Field2) — ghar(20)
- email (Field3) — char(30)
- description (Field4)
NOTE (Untitled4)
- noteid (Key) — 기본 키 — NOT NULL
- description (Field) — text
- client id (Key2) — int(5) — 외래 키 → CLIENT.client id — NOT NULL
- serviceid (Key3) — int(1000) — 외래 키 → SERVICE.serviceid — NOT NULL
- managerid (Key4) — int(100) — 외래 키 → MANAGER.managerid — NOT NULL
SERVICE (Untitled5)
- serviceid (Key) — int(1000) — 기본 키 — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
- year (Field3) — int(4)
- month (Field4) — int(2)
- fee (Field5)
- providerid (Key2) — int(100) — 외래 키 → SERVICEPROVIDER.providerid — NOT NULL
- subjectid (Key3) — 외래 키 → SUBJECT.subjectid — NOT NULL
SERVICE MANAGER (Untitled8)
- serviceid (Key2) — int(1000) — 외래 키 → SERVICE.serviceid — NOT NULL
SERVICEPROVIDER (Untitled6)
- providerid (Key) — int(100) — 기본 키 — NOT NULL
- name (Field) — char(100)
- address (Field2)
- phone (Field3) — int(12)
- grade (Field4) — float(3)
- memo (Field5) — longtext
- type (Field6)
SUBJECT (Untitled7)
- subjectid (Key) — 기본 키 — NOT NULL
- name (Field) — char(30)
- memo (Field2)
- Field3