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