counselor-han

Tables (8)

Untitled5 (books)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → consultation data.Key — NOT NULL
  • Key (counselorID) — char(4) — Foreign key → consultation data.Key — NOT NULL

Untitled6 (art)

  • Key (artID) — Primary key — NOT NULL
  • Key — Foreign key → consultation data.Key — NOT NULL
  • Key (counselorID) — char(4) — Foreign key → consultation data.Key — NOT NULL

child

  • childs (childID) — char(50) — Primary key — NOT NULL
  • name — char(50)
  • adress — char(50)
  • phone — char(50)
  • school — char(10)

conselor (counselor)

  • Key (counselorID) — char(4) — Primary key — NOT NULL
  • Field (name) — char(4)
  • Field (phone) — char(4)
  • Field (adress) — char(4)
  • Field (major) — char(4)

consultation data (consulting tata)

  • Key — Primary key — NOT NULL
  • Key (counselorID) — char(4) — Foreign key → conselor.Key — NOT NULL
  • Key (Key2) — Foreign key → consultation data.Key — NOT NULL
  • Key (counselorID2) — char(4) — Foreign key → consultation data.Key — NOT NULL
  • Key (Key3) — Foreign key → consultation data.Key — NOT NULL
  • Key (counselorID3) — char(4) — Foreign key → consultation data.Key — NOT NULL
  • Key (Key4) — Foreign key → consultation data.Key — NOT NULL
  • Key (counselorID4) — char(4) — Foreign key → consultation data.Key — NOT NULL
  • Key (Key5) — Foreign key → consultation data.Key — NOT NULL
  • Key (counselorID5) — char(4) — Foreign key → consultation data.Key — NOT NULL

consulting

  • Key (consulting) — char(4) — Primary key — NOT NULL
  • Field
  • childs (childID) — char(50) — Foreign key → child.childs — NOT NULL

movie

  • Key — Primary key — NOT NULL
  • Key (Key3) — Foreign key → consultation data.Key — NOT NULL
  • Key (counselorID2) — char(4) — Foreign key → consultation data.Key — NOT NULL
  • Key (Key2) — Foreign key → consultation data.Key — NOT NULL
  • Key (counselorID) — char(4) — Foreign key → consultation data.Key — NOT NULL

music

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → consultation data.Key — NOT NULL
  • Key (counselorID) — char(4) — Foreign key → consultation data.Key — NOT NULL