Semi

Tables (5)

Client (고객)

  • ClientNo (고객번호) — Primary key — NOT NULL
  • Name (고객이름)

Email (Untitled)

  • EmailNo (Key) — Primary key — NOT NULL
  • ClientNo (고객번호) — Foreign key → Client.ClientNo — NOT NULL
  • EmailAddrass (Field)
  • EmailKindNo (Key2) — Foreign key → EmailKind.EmailKindNo — NOT NULL

EmailKind (Untitled2)

  • EmailKindNo (Key) — Primary key — NOT NULL

Number (Untitled3)

  • NumberId (Key) — Primary key — NOT NULL
  • ClientNo (고객번호) — Foreign key → Client.ClientNo — NOT NULL
  • NumberKindNo (Key2) — Foreign key → NumberKind.NumberKindNo — NOT NULL
  • PhoneNumber (Field)

NumberKind (Untitled4)

  • NumberKindNo (Key) — Primary key — NOT NULL