Feedback 실습3
테이블 (13)
(note) (Untitled10)
- noteid (Key) — 기본 키 — NOT NULL
- serid (Key2) — 외래 키 → service.serid — NOT NULL
- description (Field)
DEPENDENT (Untitled3)
- depssn (Key2) — char(20) — 기본 키 — NOT NULL
- name (Field) — char(10)
- phone (Field2) — char(11)
- age (Field3) — int(2)
- ssn (Key) — char(20) — 외래 키 → MEMBER.ssn — NOT NULL
ENROLL (Untitled4)
- serCODE (Key) — char(10) — 외래 키 → SERVICE.serCODE — NOT NULL
- ssn (Key2) — char(20) — 외래 키 → MEMBER.ssn — NOT NULL
- date (Field) — char(8)
MEMBER (Untitled2)
- ssn (Key) — char(20) — 기본 키 — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
- phone (Field3) — char(11)
- age (Field4) — int(2)
PROVIDER (Untitled5)
- proID (Key) — char(5) — 기본 키 — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(30)
- phone (Field3) — char(11)
- affiliation (Field4) — char(5)
SERVICE (Untitled)
- serCODE (Key) — char(10) — 기본 키 — NOT NULL
- explantion (Field) — text
- proID (Key2) — char(5) — 외래 키 → PROVIDER.proID — NOT NULL
client (Untitled6)
- clientid (Key) — 기본 키 — NOT NULL
- name (Field)
- address (Field2)
- phone (Field3)
- email (Field4)
- ssn (Field5)
dependent (Untitled7)
- dependentid (Key) — 기본 키 — NOT NULL
- clientid (Key2) — 외래 키 → client.clientid — NOT NULL
- name (Field)
- phone (Field2)
- ssn (Field3)
enroll (Untitled9)
- enrollID (Key) — 기본 키 — NOT NULL
- clientid (Key2) — 외래 키 → client.clientid — NOT NULL
- serid (Key3) — 외래 키 → service.serid — NOT NULL
- grade (Field)
- review (Field2) — longtext
- date (Field3) — date
manager (Untitled12)
- manaid (Key) — 기본 키 — NOT NULL
- name (Field)
- phone (Field2)
- email (Field3)
- description (Field4)
service (Untitled8)
- serid (Key) — 기본 키 — NOT NULL
- proid (Key2) — 외래 키 → serviceprovider.proid — NOT NULL
- subid (Key3) — 외래 키 → subject(category).subid — NOT NULL
- name (Field)
- description (Field2)
- year (Field3)
- month (Field4)
- fee (Field5)
- manaid (Key5) — 외래 키 → manager.manaid — NOT NULL
serviceprovider (Untitled13)
- proid (Key) — 기본 키 — NOT NULL
- name (Field)
- address (Field2)
- phone (Field3)
- type (Field4)
subject(category) (Untitled11)
- subid (Key) — 기본 키 — NOT NULL
- name (Field)
- memo (Field2)