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)