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