ㅇㅇㅇ

테이블 (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)