market_kruly
Tables (20)
Ad
- ad_idx — bigint — Primary key — NOT NULL
- url — text
- image — text
- category_idx — bigint — Foreign key → Category.category_idx — NOT NULL
Address
- address_idx — bigint — Primary key — NOT NULL
- desc (address_desc) — text
- default_yn — varchar(2)
- recevied_name — varchar(20)
- recevied_phone — varchar(20)
- user_idx — bigint — Foreign key → User.user_idx — NOT NULL
Brand
- brand_idx — bigint — Primary key — NOT NULL
- brand_name — varchar(40)
- delete_yn — varchar(2)
Cart
- user_idx — bigint — Foreign key → User.user_idx — NOT NULL
- product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
- product_amount — tinyint
CategortProductMapping
- product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
- category_idx — bigint — Foreign key → Category.category_idx — NOT NULL
Category
- category_idx — bigint — Primary key — NOT NULL
- create_at — timestamp — NOT NULL
- update_at — timestamp — NOT NULL
- delete_yn — varchar(2) — NOT NULL
- name — varchar(40)
- category_parent — bigint
Coupon
- coupon_idx — bigint — Primary key — NOT NULL
- name (coupon_name) — varchar(40) — NOT NULL
- allowable_price — int
- specific_yn — varchar(2)
- start_time — timestamp
- end_time — timestamp
- codition — varchar(100)
Favorite
- product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
- user_idx — bigint — Foreign key → User.user_idx — NOT NULL
- create_at — timestamp
- update_at — timestamp
- delete_yn — varchar(2)
Order
- order_idx — bigint — Primary key — NOT NULL
- product_price — int
- delivery_fee — varchar(20)
- product_discount — int
- coupon_discount — int
- use_point — int
- final_fee (payment_fee) — bigint
- earn point — int
- pay_method — varchar(20)
- user_idx — bigint — Foreign key → User.user_idx — NOT NULL
- orderer — varchar(40)
- sender — varchar(40)
- recevied_name — varchar(20)
- recevied_phone (recipient_phone) — varchar(20)
- deliver_method — varchar(20)
- address_desc — text
- pickup_location — varchar(40)
- entrance_method — varchar(40)
- packaging_method — varchar(40)
- notify_time — varchar(40)
- non_release — varchar(40)
- create_at — timestamp
- update_at — timestamp
- delete_yn — varchar(2)
OrderProductMapping
- order_idx — bigint — Foreign key → Order.order_idx — NOT NULL
- product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
- price — int
- discount — int
- amount — int
Product
- product_idx — bigint — Primary key — NOT NULL
- create_at — timestamp
- update_at — timestamp
- delete_yn — varchar(2)
- brand_idx — bigint — Foreign key → Brand.brand_idx — NOT NULL
- discount — int
- discount_price — int
- price — int
- name — varchar(40)
- subname — varchar(40)
- sales_unit — varchar(40)
- weight — varchar(40)
- type — varchar(40)
- packaging_type — varchar(40)
- Allergie_info — text
- distinct_delivery — varchar(40)
- source — varchar(40)
- notice — varchar(100)
- desc_html — text
ProductDetailList
- product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
- name — varchar(40)
- origin_price — int
- discount_price — int
- save_point_yn — varchar(2)
- index — int
ProductImage
- productimage_idx — bigint — Primary key — NOT NULL
- product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
- url — text
ProductQnA
- qna_idx — bigint — Primary key — NOT NULL
- product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
- user_idx — bigint — Foreign key → User.user_idx — NOT NULL
- praent_idx — bigint
- qna_desc — text
- create_at — timestamp — NOT NULL
- update_at — timestamp
- delete_yn — varchar(2)
ProductReview
- review_idx — bigint — Primary key — NOT NULL
- review_desc — text
- user_idx — bigint — Foreign key → User.user_idx — NOT NULL
- product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
- create_at — timestamp — NOT NULL
- update_at — timestamp
- delete_yn — varchar(2)
Untitled
User
- user_idx — bigint — Primary key — NOT NULL
- create_at — timestamp — NOT NULL
- update_at — timestamp
- delete_yn — varchar(2)
- id — varchar(20)
- pwd — text
- email — varchar(20)
- phone — varchar(20)
- birth — varchar(20)
- sex — varchar(2)
- grade — varchar(5)
- name (Field) — varchar(20)
UserCouponMapping
- coupon_idx — bigint — Foreign key → Coupon.coupon_idx — NOT NULL
- user_idx — bigint — Foreign key → User.user_idx — NOT NULL
- create_at — timestamp — NOT NULL
- update_at — timestamp
- use_yn — varchar(2)
UserPointLog (Userpointlog)
- point_log_idx (pointlog_idx) — bigint — Primary key — NOT NULL
- user_idx — bigint — Foreign key → User.user_idx — NOT NULL
- create_at — timestamp
- is_minus — varchar(2)
- point_amount — int
UserProductMapping (UserLog)
- product_idx — bigint — Foreign key → Product.product_idx — NOT NULL
- user_idx — bigint — Foreign key → User.user_idx — NOT NULL