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)