pretzel
Tables (18)
admins
- admin_idx — INT(11) — Primary key — NOT NULL
- admin_id — VARCHAR(100) — 관리자아이디' COLLATE 'utf8mb4_general_ci
- pwd — VARCHAR(255) — 비밀번호' COLLATE 'utf8mb4_general_ci
- name — VARCHAR(50) — 이름' COLLATE 'utf8mb4_general_ci
- role — INT(1) — 0 : 일반관리자 / 1 : 슈퍼관리자
- note — TEXT — 비고' COLLATE 'utf8mb4_general_ci
- regdate — TIMESTAMP
- status — INT(1) — 상태
casts
- cast_idx — INT(11) — Primary key — NOT NULL
- movie_idx — INT(11)
- orders — INT(11)
- cast_name — VARCHAR(50)
- role — VARCHAR(50)
- cast_img — VARCHAR(255)
- INDEX — `FK_casts_movies`
crews
- crew_idx — INT(11) — Primary key — NOT NULL
- movie_idx — INT(11)
- orders — INT(11)
- crew_name — VARCHAR(50)
- job — VARCHAR(50)
- crew_img — VARCHAR(255)
- INDEX — `FK_crews_movies`
day_list
- day_idx — INT(11) — Primary key — NOT NULL
- movie_idx — INT(11) — 제목
- stack — INT(11) — 내용
day_list_backup
- day_idx — INT(11) — Primary key — NOT NULL
- movie_idx — INT(11) — 제목
- stack — INT(11) — 내용
faqs
- faq_idx — INT(11) — Primary key — NOT NULL
- title — VARCHAR(255) — 제목' COLLATE 'utf8mb4_general_ci
- type — VARCHAR(255)
- content — LONGTEXT — 내용' COLLATE 'utf8mb4_general_ci
- regdate — TIMESTAMP — 생성날짜
- status — INT(1)
- insert_admin_id — VARCHAR(100)
- delete_admin_id — VARCHAR(100)
- delete_date — TIMESTAMP
- INDEX — `faqs_ibfk_1`
- INDEX — `FK_faqs_admins`
movies
- movie_idx — INT(11) — Primary key — NOT NULL
- movie_id — INT(11)
- tmdb_title — VARCHAR(255)
- korea_title — VARCHAR(255)
- english_title — VARCHAR(255)
- storage_name — VARCHAR(255)
- thema — VARCHAR(50)
- synopsis — TEXT
- movie_url — VARCHAR(255)
- trailer_url — VARCHAR(255)
- poster_url — VARCHAR(255)
- backdrop_url — VARCHAR(255)
- movie_grade — VARCHAR(50)
- runtime — INT(11)
- release_date — VARCHAR(50)
- ai_emotion_syc — TIMESTAMP
- ai_deep_syc — TIMESTAMP
- status — VARCHAR(100)
- insert_time — DATETIME
- update_time — DATETIME
- delete_time — DATETIME
- admin_id — VARCHAR(50)
- watch_stack — INT(11)
- synchro — INT(2)
- w_teen_stack — INT(11)
- m_teen_stack — INT(11)
- w_twenty_stack — INT(11)
- m_twenty_stack — INT(11)
- w_thirty_stack — INT(11)
- m_thirty_stack — INT(11)
- w_forty_stack — INT(11)
- m_forty_stack — INT(11)
- w_fifty_stack — INT(11)
- m_fifty_stack — INT(11)
- woman_stack — INT(11)
- man_stack — INT(11)
notices
- notice_idx — INT(11) — Primary key — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- regdate — TIMESTAMP — 생성날짜
- status — INT(1)
- insert_admin_id — VARCHAR(100)
- delete_admin_id — VARCHAR(100)
- delete_date — TIMESTAMP
- INDEX — `notices_ibfk_1`
- INDEX — `FK_notices_admins`
profiles
- profile_idx — INT(11) — Primary key — NOT NULL
- name — VARCHAR(50)
- img_name — VARCHAR(255)
- regdate — TIMESTAMP
- user_id — VARCHAR(100)
- like_thema — VARCHAR(255)
- birth — VARCHAR(50)
- gender — INT(1) — 1 남자 / 0 여자
- INDEX — `FK_profiles_users`
questions
- question_idx — INT(11) — Primary key — NOT NULL
- profile_idx — INT(11)
- title — VARCHAR(255)
- content — LONGTEXT
- answer — LONGTEXT
- regdate — TIMESTAMP — 문의날짜
- ansdate — TIMESTAMP — 답변날짜
- status — INT(1) — 처리완료 0
- admin_id — VARCHAR(100)
- INDEX — `questions_ibfk_1`
- INDEX — `questions_ibfk_2`
real_time_list
- real_idx — INT(11) — Primary key — NOT NULL
- movie_idx — INT(11) — 제목
- stack — INT(11) — 내용
real_time_stack
- real_idx — INT(11) — Primary key — NOT NULL
- movie_idx — INT(11) — 제목
- stack — INT(11) — 내용
reports
- report_idx — INT(11) — Primary key — NOT NULL
- profile_idx — INT(11) — 신고한 프로필
- type — VARCHAR(100) — 신고유형' COLLATE 'utf8mb4_general_ci
- review_idx — INT(11) — 신고리뷰
- regdate — TIMESTAMP — 신고날짜
- ansdate — TIMESTAMP — 처리날짜
- status — INT(1) — 처리완료 0, 보류 1, 기본 2
- admin_id — VARCHAR(100)
- INDEX — `reports_ibfk_1`
- INDEX — `reports_ibfk_2`
- INDEX — `reports_ibfk_3`
reviews
- review_idx — INT(11) — Primary key — NOT NULL
- movie_idx — INT(11)
- profile_idx — INT(11)
- rating — INT(11)
- content — TEXT
- regdate — TIMESTAMP
- status — INT(1) — 리뷰 삭제 여부
- admin_id — VARCHAR(100)
- INDEX — `reviews_ibfk_1`
- INDEX — `reviews_ibfk_2`
- INDEX — `reviews_ibfk_3`
toss
- toss_idx — INT(11) — Primary key — NOT NULL
- orderId — VARCHAR(100) — NOT NULL — 주문 번호' COLLATE 'utf8mb4_general_ci
- orderName — VARCHAR(100) — NOT NULL — 주문 이름' COLLATE 'utf8mb4_general_ci
- amount — INT(11) — NOT NULL — 주문 금액
- approvedAt — VARCHAR(100) — NOT NULL — 결제 날짜' COLLATE 'utf8mb4_general_ci
- paymentKey — VARCHAR(100) — 결제키 ( 취소를 위해 )' COLLATE 'utf8mb4_general_ci
- user_id — VARCHAR(100) — 유저 아이디' COLLATE 'utf8mb4_general_ci
- cancelReason — VARCHAR(100) — 취소 이유' COLLATE 'utf8mb4_general_ci
- cancelAmount — INT(11) — 취소 금액
- canceledAt — VARCHAR(100) — 취소 날짜' COLLATE 'utf8mb4_general_ci
users
- user_idx — INT(11) — Primary key — NOT NULL
- user_id — VARCHAR(100) — 유저아이디' COLLATE 'utf8mb4_general_ci
- pwd — VARCHAR(255) — 비밀번호' COLLATE 'utf8mb4_general_ci
- name — VARCHAR(50) — 이름' COLLATE 'utf8mb4_general_ci
- email — VARCHAR(50) — 이메일' COLLATE 'utf8mb4_general_ci
- subs — VARCHAR(50) — 구독권' COLLATE 'utf8mb4_general_ci
- regdate — DATETIME — 가입일자
- last_login — DATETIME — 마지막 로그인 날짜
- status — INT(1) — 탈퇴여부 ( 탈퇴시 0 )
- admin_id — VARCHAR(100) — 관리자아이디' COLLATE 'utf8mb4_general_ci
- subs_date — DATETIME
- subs_update — VARCHAR(255)
- INDEX — `admin_id`
watch_movies
- watch_idx — INT(11) — Primary key — NOT NULL
- profile_idx — INT(11)
- movie_idx — INT(11)
- watch_date — TIMESTAMP
- INDEX — `watch_movies_ibfk_2`
wish_movies
- wish_idx — INT(11) — Primary key — NOT NULL
- profile_idx — INT(11)
- movie_idx — INT(11)
- INDEX — `wish_movies_ibfk_1`
- INDEX — `wish_movies_ibfk_2`