C2oor

Tables (17)

Coupons (할인쿠폰)

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.id — NOT NULL
  • coupon_name — VARCHAR(30)
  • coupon_creat_at — DATE

Inventorys (재고)

  • id — INT — Primary key — NOT NULL
  • inventory_count — INT
  • sale_at — INT

Main_categorys (메인카테고리)

  • id — INT — Primary key — NOT NULL
  • main_category_name — VARCHAR(20)

Mypages (마이페이지)

  • id — INT — Primary key — NOT NULL
  • coupon_id — INT — Foreign key → Coupons.id — NOT NULL
  • user_id — INT — Foreign key → Users.id — NOT NULL
  • reserves_id (reservse_id) — INT — Foreign key → Reserves.id — NOT NULL
  • shipping_address_id — INT — Foreign key → Shipping_address.id — NOT NULL
  • review_id — INT — Foreign key → Reviews.id — NOT NULL

Oders (주문)

  • id — INT — Primary key — NOT NULL
  • shipping_address_id — INT — Foreign key → Shipping_address.id — NOT NULL
  • payment_method_id — INT — Foreign key → Payment_methods.id — NOT NULL
  • products_id — INT — Foreign key → Products.id — NOT NULL
  • reserves_id — INT — Foreign key → Reserves.id — NOT NULL
  • oder_creat_at — DATE
  • order_price — INT

Payment_methods (결제방법)

  • id — INT — Primary key — NOT NULL
  • nobankbook_payment_id — INT — Foreign key → nobankbook_payments.id — NOT NULL
  • account_transfer_id — INT — Foreign key → account_transfers.id — NOT NULL
  • payment_method_name — VARCHAR(10)

Product_categorys (상품카테고리)

  • id — INT — Primary key — NOT NULL
  • main_id — INT — Foreign key → Main_categorys.id
  • product_category_name — VARCHAR(20)

Products (상품정보)

  • id — INT — Primary key — NOT NULL
  • product_category_id — INT — Foreign key → Product_categorys.id — NOT NULL
  • inventory_count_id — INT — Foreign key → Inventorys.id — NOT NULL
  • product_name — VARCHAR(20)
  • product_info — VARCHAR(300)
  • product_size — VARCHAR(10)
  • product_count — INT
  • product_price — INT
  • product_img_main — VARCHAR(300)
  • product_img_sub — TEXT
  • product_create_at — DATE
  • product_update_at — DATE

Reserves (적립금)

  • id — INT — Primary key — NOT NULL
  • reserves_list_id — INT — Foreign key → Reserves_list.id — NOT NULL
  • reserve_total — INT
  • reserve_used — INT
  • reserve__available — INT

Reserves_list (적립금목록)

  • id — INT — Primary key — NOT NULL
  • product_id — INT — Foreign key → Products.id — NOT NULL
  • reserves_id — INT — Foreign key → Reserves.id — NOT NULL

Reviews (리뷰)

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.id — NOT NULL
  • product_id — INT — Foreign key → Products.id — NOT NULL
  • review_title — VARCHAR(20)
  • review_text — VARCHAR(200)
  • review_creat_at (review_create_at) — DATE

Shipping_ requirements (배송요구사항)

  • id — INT — Primary key — NOT NULL
  • shipping_ requirement_text — VARCHAR(50)

Shipping_address (배송주소)

  • id — INT — Primary key — NOT NULL
  • shipping_requirement_id — INT — Foreign key → Shipping_ requirements.id — NOT NULL
  • shipping_addres — VARCHAR(100)
  • shipping_addres_detaile — VARCHAR(100)
  • shipping_zip code — INT
  • shipping_ reciever — VARCHAR(20)
  • shipping_name — VARCHAR(20)
  • shipping_phone — INT
  • shipping_email — VARCHAR(50)

Users (회원)

  • id — INT — Primary key — NOT NULL
  • user_nickname (user_id) — VARCHAR(20)
  • user_name — VARCHAR(20)
  • user_password — CHAR(16)
  • user_email — VARCHAR(50)
  • user_phone — INT
  • user_creat_at — DATE

account_transfers (계좌이체)

  • id — INT — Primary key — NOT NULL
  • account_transfer_name — VARCHAR(20)

carts (장바구니)

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.id — NOT NULL
  • product_id — INT — Foreign key → Products.id — NOT NULL
  • coupon_id — INT — Foreign key → Coupons.id — NOT NULL
  • reserve_id — INT — Foreign key → Reserves.id — NOT NULL
  • cart_price — INT
  • cart_count — INT

nobankbook_payments (무통장결제)

  • id — INT — Primary key — NOT NULL
  • nobankbook_payment_bank — VARCHAR(15)
  • nobankbook_payment_name — VARCHAR(20)