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)