d

Tables (24)

movmov_community_comments

  • COMMENT — 'SEQ — SEQ 사용해서 자동부여
  • _NO — NUMBER(5) — NOT NULL — POST_NO` NUMBER(5) NOT NULL COMMENT '게시글 번호 외래키
  • user_id — varchar2(100) — NOT NULL
  • COMMENT — '대댓글일 — NOT NULL — 대댓글일 때, 원댓글의 아이디'_CONTENT` VARCHAR2(1000) NOT NULL `COMMENT '신규가
  • 포인트 — 사용 — NOT NULL — 추천 받은 게시글 번호',_UPDATED_DATE` DATE NOT NULL DEFAULT SYSDATE `COMMENT '추천 받은 댓글 번호
  • _IS_DELETED — CHAR(1) — NOT NULL — 추천한 유저 (게시글/댓글당 최대 1)'_is_REPORTED` CHAR(1) NOT NULL DEFAULT 'N' `comment_parent_no` NUMBER(5) NULL COMMENT '유형고유번호

movmov_community_post_upvotes

  • POST_NO — NUMBER(5) — 게시글, 공지사항, 문의사항 등' `COMMENT 'seq
  • _NO — NUMBER(5) — NOT NULL — user_id` varchar2(100) NOT NULL COMMENT 'notice=공지사항, faq=자주 묻는 질문, inquiry=문의유형

movmov_community_posts

  • POST_NO — NUMBER(5) — Primary key — NOT NULL — seq
  • user_id — varchar2(100) — NOT NULL
  • POST_HEADER — NUMBER(3) — NOT NULL — seq
  • POST_BOARD — NUMBER(3) — NOT NULL — 여러명
  • POST_TITLE — VARCHAR2(255) — NOT NULL
  • POST_CONTENT — VARCHAR2(4000) — NOT NULL
  • POST_CREATED_DATE — DATE — NOT NULL
  • POST_UPDATED_DATE — DATE — NOT NULL
  • POST_VIEW_COUNT — NUMBER(5) — NOT NULL
  • POST_UPVOTE_COUNT — NUMBER(5) — NOT NULL
  • POST_IS_DELETED — CHAR(1) — NOT NULL
  • POST_IS_REPORTED — CHAR(1) — NOT NULL

movmov_community_reports

  • REPORT_NO — NUMBER(5) — Primary key — NOT NULL — SEQ사용
  • REPORT_CAT — NUMBER(3) — NOT NULL — 유형고유번호
  • REPORT_DETAIL — VARCHAR2(3000)
  • user_id — varchar2(100) — NOT NULL
  • report_type — varchar2(50) — NOT NULL — post, comment
  • report_content_no — NUMBER(5) — NOT NULL — 게시글/댓글 번호

movmov_content_categories

  • CAT_ID — NUMBER(3) — Primary key — NOT NULL — 유형고유번호
  • CAT_NAME — VARCHAR2(255) — NOT NULL — 0=고정, 1=일반
  • CAT_TYPE — VARCHAR2(300) — SEQUENCE 사용해서 자동부여

movmov_cs_posts

  • post_id — number(5) — Primary key — NOT NULL — 유형고유번호
  • post_type — varchar2(20) — NOT NULL — 게시판 번호
  • CAT_ID — NUMBER(3) — NOT NULL — seq
  • post_title — varchar2(255) — NOT NULL
  • post_content — varchar2(3000) — NOT NULL
  • post_top — number(1) — NOT NULL — 결제 완료, 결제 취소 등' `created_date` date NOT NULL DEFAULT sysdat
  • updated_date — date — NOT NULL
  • view_count — number(5) — NOT NULL

movmov_cs_user_inquiries

  • inquiry_id — number(5) — Primary key — NOT NULL — seq
  • user_id — varchar2(100) — NOT NULL
  • CAT_ID — NUMBER(3) — NOT NULL — 1: 회원정보, 2:영화정보, 3: 커뮤니티, 4: 상품 5: 결제, 6: 기타
  • inquiry_title — varchar2(255) — NOT NULL
  • inquiry_content — varchar2(3000) — NOT NULL
  • inquiry_created_date — date — NOT NULL
  • inquiry_answer_date — date
  • inquiry_status — number(1) — NOT NULL — 1:미답변 2:답변완료
  • inquiry_is_secret — number(1) — NOT NULL — 0: 공개글 1: 비공개글

movmov_movie_genre_map

  • movie_no — number(5) — Foreign key → movmov_movies.movie_no — NOT NULL — seq
  • genre_no — number(5) — Foreign key → movmov_movie_genres.genre_no — NOT NULL — seq

movmov_movie_genres

  • genre_no — number(2) — Primary key — NOT NULL — 분
  • genre_name — varchar2(30) — NOT NULL

movmov_movie_reviews

  • review_no — number(5) — Primary key — NOT NULL — default
  • review_star — number(1) — NOT NULL
  • review_comment — varchar2(500)
  • review_created_time — date — NOT NULL
  • review_updated_time — date — NOT NULL
  • user_id — varchar2(100) — NOT NULL
  • movie_no — number(5) — NOT NULL
  • review_open_status — char(1) — NOT NULL

movmov_movies

  • movie_no — number(5) — Primary key — NOT NULL
  • movie_director — varchar2(255) — NOT NULL
  • movie_actor — varchar2(255) — NOT NULL
  • movie_length — number(4) — NOT NULL
  • movie_poster_image_path — varchar2(200) — NOT NULL
  • movie_plot — varchar2(1000) — NOT NULL
  • movie_release_year — number(4) — NOT NULL

movmov_payment_histories

  • pay_id — number(6) — Primary key — NOT NULL
  • pay_status_id — NUMBER(2) — NOT NULL
  • user_id — varchar2(100) — NOT NULL
  • item_id — NUMBER(6) — NOT NULL
  • option_id — NUMBER(3)
  • pay_amount — NUMBER — NOT NULL
  • pay_date — DATE — NOT NULL
  • pt_use_amount — NUMBER(6)
  • pt_earn_amount — NUMBER(6) — NOT NULL
  • addr_id — number(6) — NOT NULL
  • pay_method_id — number(2) — NOT NULL
  • request — varchar2(50)

movmov_payment_methods

  • pay_method_id — number(2) — Primary key — NOT NULL
  • pay_method_title — varchar2(10) — NOT NULL

movmov_payment_status

  • pay_status_id — NUMBER(2) — Primary key — NOT NULL
  • pay_status — VARCHAR2(20) — NOT NULL — default

movmov_point_earn_types

  • type_id — number(6) — Primary key — NOT NULL
  • type_name — varchar2(20) — NOT NULL — 유형이름

movmov_point_histories

  • point_id — NUMBER(6) — Primary key — NOT NULL
  • point_change_amount — NUMBER(6) — NOT NULL
  • type_id — NUMBER(6) — NOT NULL
  • pay_id — NUMBER(6) — NOT NULL
  • point_current_total — NUMBER(6)
  • user_id — varchar2(100) — NOT NULL

movmov_shop_cart_items

  • cart_item_no — NUMBER(5) — Primary key — NOT NULL
  • item_quantity — NUMBER(3)
  • item_created_date — DATE
  • item_updated_date — DATE
  • user_id — varchar2(100) — NOT NULL
  • item_no — NUMBER(6) — NOT NULL
  • option_no — NUMBER(3)

movmov_shop_item_categories

  • category_no — NUMBER(3) — Primary key — NOT NULL
  • category_name — VARCHAR2(100) — NOT NULL

movmov_shop_item_options

  • option_no — NUMBER(3) — Primary key — NOT NULL
  • option_name — VARCHAR2(100) — NOT NULL
  • item_stock — NUMBER(5) — NOT NULL
  • item_no — NUMBER(6) — NOT NULL

movmov_shop_item_sellers

  • seller_id — NUMBER(3) — Primary key — NOT NULL
  • seller_name — VARCHAR2(255) — NOT NULL

movmov_shop_items

  • item_no — NUMBER(6) — Primary key — NOT NULL
  • item_name — VARCHAR2(255) — NOT NULL
  • item_component — VARCHAR2(255)
  • item_description — VARCHAR2(2000)
  • item_price — NUMBER(7) — NOT NULL
  • item_discount_rate — NUMBER(3) — CHECK (item_discount_rate BETWEEN 0 AND 100)
  • item_stock — NUMBER(5)
  • item_sold_out — CHAR(1)
  • item_image_path — VARCHAR2(500) — url일수도있으니 2000자로 변경 고려
  • item_created_date — DATE
  • item_updated_date — DATE
  • category_no — NUMBER(3) — NOT NULL
  • seller_id — NUMBER(3) — NOT NULL
  • item_has_option — CHAR(1)

movmov_user_addresses

  • addr_id — number(6) — Primary key — NOT NULL
  • addr_name — varchar2(10) — NOT NULL
  • addr_road — varchar2(50) — NOT NULL
  • addr_detail — varchar2(50)
  • user_id — varchar2(100) — NOT NULL
  • addr_id2 — number(6) — NOT NULL

movmov_users

  • user_id — varchar2(100) — Primary key — NOT NULL
  • user_name — varchar2(50) — NOT NULL
  • user_password — varchar2(100) — NOT NULL
  • user_nickname — varchar2(50) — NOT NULL
  • uesr_email — varchar2(255) — NOT NULL
  • user_created_date — date — NOT NULL
  • user_region — varchar2(30)
  • user_profile_image — varchar2(255)
  • user_point — number — NOT NULL
  • user_is_deleted — char(1) — NOT NULL

movmov_wish_movies

  • wish_movie_no — number(5) — Primary key — NOT NULL — seq
  • wish_movie_created_date — date — NOT NULL
  • movie_no — number(5) — NOT NULL
  • user_id — varchar2(100) — NOT NULL