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