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`