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