poster4j

Tables (12)

canceled_order

  • order_id — NUMBER — Foreign key → order_detail.order_id — NOT NULL
  • product_id — NUMBER — Foreign key → order_detail.product_id — NOT NULL
  • option_size — VARCHAR2(50) — Foreign key → order_detail.option_size — NOT NULL
  • option_frame — VARCHAR2(50) — Foreign key → order_detail.option_frame — NOT NULL
  • order_cancel_category — VARCHAR2(20) — NOT NULL
  • order_cancel_reason — VARCHAR2(100) — NOT NULL
  • order_cancel_req_date — DATE — NOT NULL
  • order_cancel_cmptn_date — DATE — NOT NULL

cart

  • option_size — VARCHAR2(50) — Primary key — NOT NULL
  • option_frame — VARCHAR2(50) — Primary key — NOT NULL
  • customer_id — VARCHAR2(20) — Foreign key → customer.customer_id — NOT NULL
  • product_id — NUMBER — Foreign key → product.product_id — NOT NULL
  • cart_product_quantity — NUMBER — NOT NULL
  • cart_product_checked — VARCHAR2(20) — NOT NULL

customer

  • customer_id — VARCHAR2(20) — Primary key — NOT NULL
  • customer_password — VARCHAR2(100) — NOT NULL
  • customer_name — VARCHAR2(30) — NOT NULL
  • customer_telno — VARCHAR2(30) — NOT NULL
  • customer_email — VARCHAR2(50) — NOT NULL
  • customer_term_agree — VARCHAR2(20)
  • customer_info_agree — VARCHAR2(20)
  • customer_sms_agree — VARCHAR2(20)
  • customer_email_agree — VARCHAR2(20)
  • customer_enabled — VARCHAR2(20) — NOT NULL

order_detail

  • option_size — VARCHAR2(50) — Primary key — NOT NULL
  • option_frame — VARCHAR2(50) — Primary key — NOT NULL
  • order_id — NUMBER — Foreign key → order_t.order_id — NOT NULL
  • product_id — NUMBER — Foreign key → product.product_id — NOT NULL
  • order_detail_quantity — NUMBER — NOT NULL
  • order_detail_price — NUMBER — NOT NULL
  • order_detail_status — VARCHAR2(20) — NOT NULL
  • order_dl_cmptn_date — DATE

order_t

  • order_id — NUMBER — Primary key — NOT NULL
  • customer_id — VARCHAR2(20) — Foreign key → customer.customer_id — NOT NULL
  • receiver_id — NUMBER — Foreign key → receiver.receiver_id — NOT NULL
  • order_date — DATE — NOT NULL
  • order_settlement_method — VARCHAR2(30) — NOT NULL
  • order_delivery_demand — VARCHAR2(100)

product

  • product_id — NUMBER — Primary key — NOT NULL
  • product_name — VARCHAR2(50) — NOT NULL
  • product_price — NUMBER — NOT NULL
  • product_discount_rate — FLOAT — NOT NULL
  • product_theme — VARCHAR2(20) — NOT NULL
  • product_artist — VARCHAR2(20) — NOT NULL
  • product_detail — VARCHAR2(600)
  • product_enabled — VARCHAR2(20) — NOT NULL

product_image

  • product_image_name — VARCHAR2(20) — Primary key — NOT NULL
  • product_id — NUMBER — Foreign key → product.product_id — NOT NULL
  • product_image_ctgry — VARCHAR2(20) — NOT NULL
  • product_image_type — VARCHAR2(30) — NOT NULL
  • product_image_source — BLOB — NOT NULL

product_inquiry

  • product_inquiry_id — NUMBER — Primary key — NOT NULL
  • customer_id — VARCHAR2(20) — Foreign key → customer.customer_id — NOT NULL
  • product_id — NUMBER — Foreign key → product.product_id — NOT NULL
  • product_inquiry_content — VARCHAR2(200) — NOT NULL
  • product_inquiry_date — DATE — NOT NULL
  • product_inquiry_answered — VARCHAR2(20) — NOT NULL

product_inquiry_answer

  • product_inquiry_id — NUMBER — Foreign key → product_inquiry.product_inquiry_id — NOT NULL
  • product_inquiry_answer_content — VARCHAR2(200) — NOT NULL
  • product_inquriy_answer_date — DATE — NOT NULL

receiver

  • receiver_id — NUMBER — Primary key — NOT NULL
  • customer_id — VARCHAR2(20) — Foreign key → customer.customer_id — NOT NULL
  • receiver_name — VARCHAR2(30) — NOT NULL
  • receiver_zip — VARCHAR2(10) — NOT NULL
  • receiver_address — VARCHAR2(50) — NOT NULL
  • receiver_address_detail — VARCHAR2(50)
  • receiver_address_type — VARCHAR2(20) — NOT NULL
  • receiver_telno — VARCHAR2(20) — NOT NULL
  • receiver_person_name — VARCHAR2(20) — NOT NULL
  • receiver_enabled — VARCHAR2(20) — NOT NULL

review

  • order_id — NUMBER — Foreign key → order_detail.order_id — NOT NULL
  • product_id — NUMBER — Foreign key → order_detail.product_id — NOT NULL
  • option_size — VARCHAR2(50) — Foreign key → order_detail.option_size — NOT NULL
  • option_frame — VARCHAR2(50) — Foreign key → order_detail.option_frame — NOT NULL
  • review_star_rating — NUMBER — NOT NULL
  • review_content — VARCHAR2(600) — NOT NULL
  • review_written_date — DATE — NOT NULL

review_image

  • review_image_id — NUMBER — Primary key — NOT NULL
  • order_id — NUMBER — Foreign key → review.order_id — NOT NULL
  • product_id — NUMBER — Foreign key → review.product_id — NOT NULL
  • option_size — VARCHAR2(50) — Foreign key → review.option_size — NOT NULL
  • option_frame — VARCHAR2(50) — Foreign key → review.option_frame — NOT NULL
  • review_image_name — VARCHAR2(100) — NOT NULL
  • review_image_type — VARCHAR2(30) — NOT NULL
  • review_image_source — BLOB — NOT NULL