DB_module
Tables (15)
ArtGroup (Untitled5)
- Kind_of_Art (Key) — Primary key — NOT NULL
Artist (Untitled3)
- Artist_name (Key) — Primary key — NOT NULL
- Birthplace (Field)
- Age (Field2)
- Style (Field3)
Artwork (Untitled4)
- Title (Key) — Primary key — NOT NULL
- Year (Field)
- Type_of_Art (Field2)
- Price (Field3)
- Artist_name (Key2) — Foreign key → Artist.Artist_name — NOT NULL
Course Session(Bridge) (Untitled13)
- Course_ID (Key) — Foreign key → Courses.Course_ID — NOT NULL
- Session_ID (Key2) — Foreign key → Training Session.Session_ID — NOT NULL
- Trainee_ID (Key3) — Foreign key → Trainee.Trainee_ID — NOT NULL
Courses (Untitled9)
- Course_ID (Key) — Primary key — NOT NULL
- Course_Name (Field)
- Team_ID (Key2) — Foreign key → Teaching Team.Team_ID — NOT NULL
- Inst_ID (Key22) — Foreign key → Teaching Team.Inst_ID — NOT NULL
Grouped (Untitled6)
- Title (Key) — Foreign key → Artwork.Title — NOT NULL
- Kind_of_Art (Key2) — Foreign key → ArtGroup.Kind_of_Art — NOT NULL
Instructor (Untitled7)
- Inst_ID (Key) — Primary key — NOT NULL
- Inst_Name (Field)
Product (Untitled)
- Pct_Code (Key) — Primary key — NOT NULL
- Price (Field2)
- Description (Field)
Region
- Reg_Code (Dep_ID) — Primary key — NOT NULL
- Name (Field)
Research (Untitled11)
- Res_ID (Key) — Primary key — NOT NULL
- Inst_ID (Key2) — Foreign key → Instructor.Inst_ID — NOT NULL
- Res_Name (Field)
Sell (Untitled2)
- Str_Code (Emp_ID) — Foreign key → Store.Str_Code — NOT NULL
- Pct_Code (Key) — Foreign key → Product.Pct_Code — NOT NULL
Store (Employee)
- Str_Code (Emp_ID) — Primary key — NOT NULL
- Address (Field)
- Reg_Code (Dep_ID) — Foreign key → Region.Reg_Code — NOT NULL
Teaching Team (Untitled10)
- Team_ID (Key) — Primary key — NOT NULL
- Inst_ID (Key2) — Foreign key → Instructor.Inst_ID — NOT NULL
Trainee (Untitled8)
- Trainee_ID (Key) — Primary key — NOT NULL
- Trainee_Name (Field)
Training Session (Untitled12)
- Session_ID (Key) — Primary key — NOT NULL
- Session_Name (Field)