Database_2

Tables (7)

Untitled (Member)

  • Key (MemberID) — char(20) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field (phone) — char(13)

Untitled (Department)

  • Key (departmentID) — char(20) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (birth_date) — interger(8)
  • Key (MemberID) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (Service)

  • Key (Service_code) — char(20) — Primary key — NOT NULL
  • Field (explain) — char(30)
  • Key (offererNO) — char(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (Offerer)

  • Key (offererNO) — char(20) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field (phone) — char(13)

Untitled (Member_Service)

  • Key (MemberID) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (Service_code) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (register_date) — interger(8)

Untitled (CLIENT)

  • Key (clientSsn) — integer(13) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(50)
  • Field (age) — char(10)
  • Field (phone) — interger(20)

Untitled (DEPENDENT)

  • Key (ssn) — interger(13) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (age) — interger(20)
  • Key (clientSsn) — integer(13) — Foreign key → Untitled.Key — NOT NULL