3
Tables (6)
CUSTOMER (Untitled)
- regNo (Key) — int(13) — Primary key — NOT NULL
- phoneNo (Key2) — int(11) — Primary key — NOT NULL
- name (Field) — char(3)
- address (Field2) — char(10)
- regNo (Key3) — int(13) — Foreign key → DEPENDENT.regNo — NOT NULL
- phoneNo (Key22) — int(11)\ — Foreign key → DEPENDENT.phoneNo — NOT NULL
DEPENDENT (Untitled2)
- regNo (Key) — int(13) — Primary key — NOT NULL
- phoneNo (Key2) — int(11)\ — Primary key — NOT NULL
- name (Field2) — char(3)
- old (Field3) — int(2)
ORGANIZATION (Untitled3)
- regNo (Key) — int(13) — Foreign key → SEVERCE PRO.regNo — NOT NULL
- phoneNo (Key2) — int(11) — Foreign key → SEVERCE PRO.phoneNo — NOT NULL
- regNo (Key3) — int(13) — Foreign key → CUSTOMER.regNo — NOT NULL
- phoneNo (Key22) — int(11) — Foreign key → CUSTOMER.phoneNo — NOT NULL
SEVER (Untitled4)
- severNo (Key) — int(10) — Primary key — NOT NULL
- regNo (Key2) — int(13) — Foreign key → SEVERCE PRO.regNo — NOT NULL
- phoneNo (Key22) — int(11) — Foreign key → SEVERCE PRO.phoneNo — NOT NULL
- explanation (Field) — data
- regNo (Key3) — int(13) — Foreign key → CUSTOMER.regNo — NOT NULL
- phoneNo (Key23) — int(11) — Foreign key → CUSTOMER.phoneNo — NOT NULL
SEVERCE PRO (Untitled5)
- regNo (Key) — int(13) — Primary key — NOT NULL
- phoneNo (Key2) — int(11) — Primary key — NOT NULL
- address (Field2) — char(10)
- name (Field) — char(3)
TIME (Untitled6)
- severNo (Key) — int(10) — Foreign key → SEVER.severNo — NOT NULL
- regNo (Key2) — int(13) — Foreign key → SEVER.regNo — NOT NULL
- phoneNo (Key22) — int(11) — Foreign key → SEVER.phoneNo — NOT NULL
- regNo (Key3) — int(13) — Foreign key → CUSTOMER.regNo — NOT NULL
- phoneNo (Key23) — int(11) — Foreign key → CUSTOMER.phoneNo — NOT NULL