3周作业
Tables (4)
DEPENDENT (Untitled3)
- depID (Key) — char(20) — Primary key — NOT NULL
- depName (Field) — char(50)
- depAge (Field2) — char(10)
- memID (Key2) — integer — Foreign key → MEMBER.memID — NOT NULL
MEMBER (Untitled2)
- memID (Key) — integer — Primary key — NOT NULL
- memName (Field) — char(10)
- memAddress (Field2) — char
- memPhone number (Field3) — char(20)
- depID (Key2) — char(20) — Foreign key → DEPENDENT.depID — NOT NULL
SERVICE (Untitled4)
- code (Key) — char(50) — Primary key — NOT NULL
- memID (Key2) — integer — Foreign key → MEMBER.memID — NOT NULL
- explaination (Field) — char(50)
- time (Field2) — char
- ProCode (Key3) — integer — Foreign key → SERVICE PROVIDER.ProCode — NOT NULL
SERVICE PROVIDER (Untitled5)
- ProCode (Key) — integer — Primary key — NOT NULL
- Proname (Field) — char(50)
- ProAddress (Field2) — char(20)
- Pro phone number (Field3) — char(70)
- code (Key2) — char(50) — Foreign key → SERVICE.code — NOT NULL
- memID (Key22) — integer — Foreign key → SERVICE.memID — NOT NULL