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