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