Excercise5_0930
Tables (5)
CONTENT
- FK (Service Code) — INT(20) — Primary key — NOT NULL
- FK (Producer Num) — INT(20) — Primary key — NOT NULL
- PK (Service Code) — INT(20) — Foreign key → SERVICE.PK — NOT NULL
- PK (Customer ID) — INT(20) — Foreign key → SERVICE.PK — NOT NULL
- FK (Rating) — INT(20)
- FK (Price) — INT(30)
CUSTOMER
- PK (Customer ID) — INT(20) — Primary key — NOT NULL
- Field (Customer Name) — CHAR(100)
- Field (Address) — CHAR(200)
- Field (phone) — INT(20)
- Field (age) — INT(20)
FAMILY
- PK (Family ID) — INT(20) — Primary key — NOT NULL
- PK (Customer ID) — INT(20) — Foreign key → CUSTOMER.PK — NOT NULL
- Field (Family Name) — CHAR(100)
- Field (Relationship) — CHAR(100)
- Field (Family Address) — CHAR(200)
- Field (Family phone) — INT(20)
- Field (Family age) — INT(20)
PRODUCER
- PK (Producer Num) — INT(20) — Primary key — NOT NULL
- FK (Service Code) — INT(20) — Foreign key → CONTENT.FK — NOT NULL
- FK (Producer Num2) — INT(20) — Foreign key → CONTENT.FK — NOT NULL
- PK (Service Code) — INT(20) — Foreign key → CONTENT.PK — NOT NULL
- PK (Customer ID) — INT(20) — Foreign key → CONTENT.PK — NOT NULL
- Field (Producer Name) — CHAR(100)
- Field (Producer Address) — CHAR(200)
- Field (Producer Phone) — INT(20)
SERVICE
- PK (Service Code) — INT(20) — Primary key — NOT NULL
- PK (Customer ID) — INT(20) — Foreign key → CUSTOMER.PK — NOT NULL
- Field (Description) — CHAR(100)
- Field (Start Date) — INT(100)
- Field2 (End Date) — INT(100)