test

Tables (6)

CUSTOMER (Untitled5)

  • c_id (Key) — Primary key — NOT NULL
  • c_name (Field)
  • email (Field2)
  • pwd (Field3)
  • gender (Field4)
  • phone (Field5)

GENRE (Untitled4)

  • g_id (Key) — Primary key — NOT NULL
  • genre (Field)

MOVIE (Untitled)

  • m_id (M_ID) — int — Primary key — NOT NULL — 영화 식별자
  • m_type (Field) — 영화 타입
  • m_name (M_NAME) — VARCHAR(40) — NOT NULL — 영화 이름
  • start_year (START_YEAR) — DATE — 상영 연도
  • end_year (END_YEAR) — DATE — 상영 종료 연도
  • runtimes (RUNTIMES) — TIME — 상영 시간
  • is_adult (IS_ADULT) — BOOLEAN — 성인영화 여부
  • rating (RATING) — INT — 평점
  • votes (VOTES) — INT — 투표수

PARTICIPANT (Untitled2)

  • o_id (Key) — Primary key — NOT NULL
  • p_name (Field)
  • major_work (Field2)

PROFESSION (Untitled3)

  • pr_id (Field)
  • pr_name (Field2)

Untitled6

  • Field