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