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