ERD Exercise3

Tables (6)

Untitled (지역사회서비스조직)

  • Key (조직ID) — char(7) — Primary key — NOT NULL
  • Field (조직이름) — char(10)
  • Field (조직번호) — int(12)
  • Field (조직주소) — char(15)

Untitled (서비스)

  • Key (서비스명) — char(10) — Primary key — NOT NULL
  • Field (서비스코드) — char(10)
  • Field (서비스설명) — text
  • Field (서비스날짜) — date
  • Key (조직ID) — char(7) — Foreign key → Untitled.Key — NOT NULL

Untitled (여성고객)

  • Key (고객ID) — char(7) — Primary key — NOT NULL
  • Field (고객명) — char(5)
  • Field (고객주민번호) — int(13)
  • Field (고객주소) — char(15)
  • Field (고객전화번호) — int(12)
  • Key (조직ID) — char(7) — Foreign key → Untitled.Key — NOT NULL

Untitled (부양가족)

  • Key (부양가족이름) — char(5) — Primary key — NOT NULL
  • Field (부양가족주민번호) — int(13)
  • Field (부양가족주소) — char(15)
  • Field (부양가족전화번호) — int(12)
  • Key (고객ID) — char(7) — Foreign key → Untitled.Key — NOT NULL

Untitled (등록)

  • Key (서비스명) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (고객ID) — char(7) — Foreign key → Untitled.Key — NOT NULL

Untitled (서비스제공자)

  • Key (제공자고유번호) — int(10) — Primary key — NOT NULL
  • Field (제공자명) — char(5)
  • Field (제공자주소) — char(15)
  • Field (제공자연락처) — int(12)
  • Key (조직ID) — char(7) — Foreign key → Untitled.Key — NOT NULL