android_poster4j

Tables (9)

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
  • product_id (product_id2) — NUMBER — Foreign key → order_detail.product_id — NOT NULL
  • customer_id — VARCHAR2(20) — Foreign key → order_detail.customer_id — NOT NULL
  • customer_id (customer_id2) — VARCHAR2(20) — Foreign key → order_detail.customer_id — 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
  • product_id (product_id2) — NUMBER — Foreign key → product.product_id — NOT NULL
  • customer_id (customer_id2) — VARCHAR2(20) — Foreign key → product.customer_id — NOT NULL
  • customer_id (customer_id22) — VARCHAR2(20) — Foreign key → product.customer_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
  • customer_point — NUMBER

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
  • product_id (product_id2) — NUMBER — Foreign key → product.product_id — NOT NULL
  • customer_id — VARCHAR2(20) — Foreign key → product.customer_id — NOT NULL
  • customer_id (customer_id2) — VARCHAR2(20) — Foreign key → product.customer_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) — NOT NULL
  • receiver_id — NUMBER — 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_id (product_id2) — NUMBER — Foreign key → wish.product_id — NOT NULL
  • customer_id — VARCHAR2(20) — Foreign key → wish.customer_id — NOT NULL
  • customer_id (customer_id2) — VARCHAR2(20) — Foreign key → wish.customer_id — 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 (product_id2) — NUMBER — Foreign key → product.product_id — NOT NULL
  • product_id (product_id22) — NUMBER — Foreign key → product.product_id — NOT NULL
  • customer_id — VARCHAR2(20) — Foreign key → product.customer_id — NOT NULL
  • customer_id (customer_id2) — VARCHAR2(20) — Foreign key → product.customer_id — NOT NULL
  • product_id — NUMBER — NOT NULL
  • product_image_ctgry — VARCHAR2(20) — NOT NULL
  • product_image_type — VARCHAR2(30) — NOT NULL
  • product_image_source — BLOB — NOT NULL

receiver

  • receiver_id — NUMBER — Primary key — NOT NULL
  • customer_id (customer_id2) — VARCHAR2(20) — Foreign key → customer.customer_id — NOT NULL
  • customer_id — VARCHAR2(20) — 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

wish

  • product_id — NUMBER — Primary key — NOT NULL
  • customer_id — VARCHAR2(20) — Primary key — NOT NULL
  • customer_id (customer_id2) — VARCHAR2(20) — Foreign key → customer.customer_id — NOT NULL