ERD3

Tables (4)

Untitled (부양가족)

  • Key (주민등록번호) — int(13) — Primary key — NOT NULL
  • Field (이름) — char(10)
  • Field (나이) — int
  • Key (종류) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (고유번호2) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (고객정보)

  • Key (주민등록번호) — char(13) — Primary key — NOT NULL
  • Key (고유번호2) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (이름) — char(30)
  • Field (주소) — char(30)
  • Field (연락처) — char(20)
  • Key (종류) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (고유번호) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (서비스)

  • Key (종류) — char(20) — Primary key — NOT NULL
  • Field (코드) — int
  • Field (설명) — text
  • Field (제공날짜) — datetime
  • Key (주민등록번호) — int(13) — Foreign key → Untitled.Key — NOT NULL
  • Field (주정부대리인) — char(30)
  • Field (사설대리인) — char(30)
  • Key (고유번호2) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (제공자)

  • Key (고유번호) — int — Primary key — NOT NULL
  • Field (이름) — char(10)
  • Field (주소) — char(30)
  • Field (연락처) — char(20)
  • Key (종류) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (고유번호2) — int — Foreign key → Untitled.Key — NOT NULL