test
테이블 (16)
1:1문의
- movie_code — number — 기본 키 — NOT NULL
- member_code2 — varchar2(30) — 외래 키 → member.member_code — NOT NULL
- customer_id — VARCHAR2(15) — NOT NULL
- name — VARCHAR2(30) — NOT NULL
- tel_num — VARCHAR2(40) — NOT NULL
- email — VARCHAR2(50) — NOT NULL
- select_type — VARCHAR2(30) — NOT NULL
- question_type — VARCHAR2(40) — NOT NULL
- subject — VARCHAR2(50) — NOT NULL
- content — VARCHAR2(1000) — NOT NULL
- writedate — DATE
- image — VARCHAR2(50)
- individual_content — VARCHAR2(1000)
- issecret — VARCHAR2(20)
Coupon
- coupon_code — varchar2(100) — 기본 키 — NOT NULL — 시퀀스
- member_code — varchar2(30) — 외래 키 → member.member_code — NOT NULL — 1
- coupon_name — varchar2(50) — NOT NULL — 관리페이지에서
- coupon_rate — number — NOT NULL
- coupon_qty — number — NOT NULL
- coupon_remain_qty — number — NOT NULL — 잔여수량
Coupon_user
- member_code — varchar2(30) — 기본 키 — NOT NULL — customer
- coupon_code — varchar2(100) — 외래 키 → Coupon.coupon_code — NOT NULL — 시퀀스
- coupon_state — number — NOT NULL — 0:미사용
Product
- product_code — varchar2(100) — 기본 키 — NOT NULL — Product_seq로
- category_name — varchar2(30) — 외래 키 → Product_Category.category_num — NOT NULL — Product_Category
- product_name — varchar2(50) — NOT NULL
- product_detail — varchar2(1000) — NOT NULL
- product_qty — number — NOT NULL
- product_price — number — NOT NULL — 할인가가
- product_sprice — number — 세일
- product_image — varchar2(100) — NOT NULL
- product_state — number — NOT NULL — 상품
- product_point — number — NOT NULL
Product_Category
- category_num — number — 기본 키 — NOT NULL — Product_Category_seq
- category_name — VARCHAR2(30) — NOT NULL — 기프트카드/영화티켓/(음료/스낵/팝콘)/기타
Untitled3
- movie_code — varchar2(30) — 외래 키 → 영화.movie_code — NOT NULL — FK
- movie_rate — number — 18세
- movie_title — varchar2(50) — NOT NULL — 영화테이블
- movie_genre — VARCHAR(255) — 2d
- post — VARCHAR(255)
- screen — varchar2(10) — NOT NULL — 코드?
- seat — number — NOT NULL
- stime — date — NOT NULL — 시간으로
- ftime — VARCHAR(255)
- sdate — number — 예를들어
- attendance — number
VOD
- movie_code — varchar2(30) — 외래 키 → 영화.movie_code — NOT NULL — PK
- vod_num — number — NOT NULL — UNIQUE
- vod_price — number — NOT NULL
- vod_title — varchar(30) — 영화
- vod_input — date
- director — varchar2(20) — NOT NULL
- post — varchar2(50)
- grade — number
- story — varch2(4000)
amount
- amount_code — varchar2(30) — 기본 키 — NOT NULL — AM01
- time — number
- age — number
location
- location_code — varchar2(10) — 기본 키 — NOT NULL — L01
- area — varchar2(10) — NOT NULL — 서울
- branch — varchar2(10) — NOT NULL — 강남
member
- member_code — varchar2(30) — 기본 키 — NOT NULL — M01
- member_id — varchar2(30) — NOT NULL
- member_pw — varchar2(30) — NOT NULL
- member_name — varchar2(20)
- member_birth — varchar2(10)
- member_phone — varchar2(15)
- member_email — varchar2(50)
- member_pw_question — varchar2(100)
- member_pw_answer — varchar2(100)
- member_start — varchar2(10)
- member_marketing_agree — varchar2(12)
- member_email_agree — varchar2(12)
- member_sms_agree — varchar2(12)
- member_point — varchar2(12)
noncustomer
- nonmember_code — varchar2(30) — 기본 키 — NOT NULL — NM01
- nonmember_name — varchar2(30)
- nonmember_birth — varchar2(15)
- nonmember_phone — varchar2(15)
- nonmember_pw — varchar2(30)
- nonmember_agree — varchar2(15)
seat
- seat_code — varchar2(30) — 기본 키 — NOT NULL — SA01
- theater_code — VARCHAR(255) — 외래 키 → theater.theater_code — NOT NULL
- location_code — varchar2(10) — 외래 키 → theater.location_code — NOT NULL — L01
- seat_row — varchar2(5) — NOT NULL — A
- seat_num — varchar2(5) — NOT NULL — 01
theater
- theater_code — VARCHAR(255) — 기본 키 — NOT NULL
- location_code — varchar2(10) — 외래 키 → location.location_code — NOT NULL — L01
- screen_code — varchar2(10) — 1
- address — varchar2(10) — 주소
분실물
- article_code — number — 기본 키 — NOT NULL
- member_code2 — varchar2(30) — 외래 키 → member.member_code — NOT NULL
- customer_ID — VARCHAR2(30) — NOT NULL
- lost_location — VARCHAR2(30) — NOT NULL
- movie — VARCHAR2(40) — NOT NULL
- name — VARCHAR2(30) — NOT NULL
- lost_subject — VARCHAR2(50) — NOT NULL
- lost_email — VARCHAR2(50) — NOT NULL
- lost_date — VARCHAR2(20) — NOT NULL
- lost_writeDate — Date
- lost_content — VARCHAR2(1000) — NOT NULL
- lost_article — VARCHAR2(15)
영화
- movie_code — varchar2(8) — 기본 키 — NOT NULL — PK
- movie_title — varchar2(50) — NOT NULL
- movie_num — number — NOT NULL — 시퀀스
- movie_genre — varchar2(30) — NOT NULL
- movie_story — varchar2(4000)
- movie_rate — number — NOT NULL — 전체이용가
- opendate — date — NOT NULL
- movie_grade — number
- attendance — number
- movie_url — varchar2(30)
- post — varchar2(50) — 포스터
- director — varchar2(30) — NOT NULL
자주묻는질문
- movie_num — number — 기본 키 — NOT NULL
- classification — VARCHAR2(30) — NOT NULL
- question — VARCHAR2(300) — NOT NULL
- content — VARCHAR2(1000) — NOT NULL
- qdate — date — NOT NULL
- hits — number — NOT NULL