ㅇㅇㅇ
테이블 (9)
결제수단
- payment_id — number — 기본 키 — NOT NULL
- member_id — varchar2(20)
- payment_name — varchar2(10)
결제정보
- payment_id — number — 기본 키 — NOT NULL
- payment_num — number
- payment_end_dt — date
- payment_owner — varchar2(10)
- payment_security — number
- payment_pw — number
물품
- product_id — number — 기본 키 — NOT NULL
- product_name — varchar2(30)
- product_price — number
- product_amount — number
- product_sold — char(1)
- product_upload_dt — date
- product_update_dt — date
- product_img — varchar2(255)
물품주문
- order_id — number
- product_id — number
- order_product_amount — number
여행상품
- travel_id — number — 기본 키 — NOT NULL
- travel_name — varchar2(50)
- travel_price — number
- travel_amount — number
- travel_sold — char(1)
- travel_comment — varchar2(500)
- travel_label — varchar2(10)
- travel_start_dt — date
- travel_end_dt — date
- travel_upload_dt — date
- travel_update_dt — date
- travel_img — varchar2(500)
여행주문
- order_id — number
- travel_id — number
- order_travel_amount — number
주문
- order_id — number — 기본 키 — NOT NULL
- member_id — varchar2(20)
- payment_id — number
- order_dt — date
- order_state — number
회원
- member_id — varchar2(20) — 기본 키 — NOT NULL
- member_name — varchar2(10) — NOT NULL
- member_pw — varchar2(30) — NOT NULL
- member_email — varchar2(30)
- member_phone — varchar2(15)
- member_birth — date
후기
- review_id — number — 기본 키 — NOT NULL
- travel_id — number
- review_rate — number
- review_comment — varchar2(200)