과제 3 wmx
테이블 (5)
client (Untitled)
- clientSsn (Field) — int(9) — 기본 키
- clientName (Field2) — char(60)
- chientAdder (Field3) — char(60)
- clientPhone (Field4) — int(11)
- familySsn (Field5) — int(9) — 외래 키 → family.familySsn
family (Untitled2)
- familySsn (Field) — int(9) — 기본 키
- familyName (Field2) — char(60)
- familyAge (Field3) — int(3)
- clientSsn (Field4) — int(9)
provider (Untitled3)
- provId (Field) — int(9) — 기본 키
- provName (Field2) — char(60)
- provAddr (Field3) — char(60)
- provPhone (Field4) — int(11)
service (Untitled4)
- serviceId (Field) — int(9) — 기본 키
- serviceDesc (Field2) — text
servicerecord (Untitled5)
- serviceRecordId (Field) — int(9) — 기본 키
- clientSsn (Field2) — int(9)
- provId (Field3) — int(9)
- serviceId (Field4) — int(9)
- serviceDate (Field5) — date
- Field6
- provId (Field7) — int(9) — 외래 키 → provider.provId
- serviceId (Field8) — int(9) — 외래 키 → service.serviceId
- clientSsn (Field9) — int(9) — 외래 키 → client.clientSsn