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