NE(O)RDINARY HACKATHON Team R

NE(O)RDINARY HACKATHON Team R

Tables (6)

Untitled (movie)

  • Key (seq) — bigint — Primary key — NOT NULL
  • Field (kor_title) — varchar
  • Field2 (eng_title) — varchar
  • Field3 (director) — varchar
  • Field4 (actors) — varchar
  • Field (production_year) — varchar
  • Field (genre_code) — varchar
  • Field (genre_name) — varchar
  • Field (company_nm) — varchar
  • Field (distributor_nm) — varchar
  • Field (image_path) — varchar
  • Field (lss_gubun) — varchar
  • Field (duration) — varchar
  • Field (rating) — varchar
  • Field (color_type) — varchar
  • Field (synopsis) — varchar
  • Field (screenwriter) — varchar
  • Field (producer) — varchar
  • Field (release_date) — varchar
  • Field (keywords) — varchar
  • Field (detail_crawled) — boolean

Untitled (theater)

  • Key (thea_cd) — varchar — Primary key — NOT NULL
  • Field2 (scrn_cd) — varchar
  • Field3 (thea_name) — varchar
  • Field4 (scrn_name) — varchar
  • Field5 (screen_gb) — varchar
  • Field6 (designated_at) — varchar
  • Field (address) — varchar
  • Field (phone) — varchar
  • Field (fax) — varchar
  • Field (homepage) — varchar
  • Field (seat_count) — varchar
  • Field (naver_map_url) — varchar
  • Field (detail_crawled) — boolean

Untitled (saved_theater)

  • Key (thea_cd) — varchar — Foreign key → Untitled.Key — NOT NULL
  • id (user_id) — bigint — Foreign key → users.id — NOT NULL
  • Field (created_at) — datetime

Untitled (ticket)

  • Key (id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → users.id — NOT NULL
  • Key (movie_seq) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (watched_date) — date
  • Field2 (watched_time) — time
  • Field3 (cinema) — varchar
  • Field4 (review) — varchar
  • Field (show_yn) — boolean
  • Field (deleted_at) — datetime

Untitled (collection)

  • Key (id) — bigint — Primary key — NOT NULL
  • id (user_id) — bigint — Foreign key → users.id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

users

  • id — bigint — Primary key — NOT NULL
  • Field (login_id) — varchar
  • Field2 (nickname) — varchar
  • Field3 (password) — varchar
  • Field (intro) — varchar
  • Field4 (created_at) — datetime
  • Field (updated_at) — datetime
  • Field2 (deleted_at) — datetime