Group5
Tables (7)
Genr (Untitled3)
- g_id (primary) — Primary key — NOT NULL
- g_name (Field)
Genre (Untitled7)
- ge_id (primary) — int — Primary key — NOT NULL
- ge_name (Field) — varchar(30)
- ge_question_str (Field2)
In_Genr (Untitled4)
- ig_id (primary) — Primary key — NOT NULL
- g_id (primary3) — Foreign key → Genr.g_id — NOT NULL
- m_id (primary2) — Foreign key → Movie.m_id — NOT NULL
- q_id (Key) — Foreign key → Question.q_id — NOT NULL
Mo_Ge (Untitled6)
- mo_ge_id (primary) — int — Primary key — NOT NULL
- mo_id (foriegn1) — int — Foreign key → Movie.mo_id — NOT NULL
- ge_id (foriegn2) — int — Foreign key → Genre.ge_id — NOT NULL
Movie (Untitled)
- m_id (primary) — int — Primary key — NOT NULL
- m_name (Field) — varchar(50)
- 평정 (Field2) — int
- 관객수 (Field3) — decimal(5,7)
- 년도 (Field4) — date
- Field5
Movie (Untitled5)
- mo_id (primary) — int — Primary key — NOT NULL
- mo_name (Field) — varchar(30)
- mo_year (Field2) — dateyear
- Field3
Question (Untitled2)
- q_id (Key) — Primary key — NOT NULL
- str (Field)