beompingmall
Tables (9)
Like (찜)
- product_id (제품 아이디) — Foreign key → Product.id — NOT NULL
- user_id (유저 아이디) — Foreign key → User.id — NOT NULL
Order_Item (주문제품)
- id (PK) — Primary key — NOT NULL
- order_id (주문 아이디) — Foreign key → Orders.id — NOT NULL
- product_id (제품 아이디) — Foreign key → Product.id — NOT NULL
- id (Key) — Foreign key → Orders.address_id — NOT NULL
- id (PK2) — Foreign key → Orders.user_id — NOT NULL
- id (PK22) — Foreign key → Orders.id — NOT NULL
- product_name (제품명)
- quentity (수량)
- price (가격)
Orders (주문)
- id (PK) — Primary key — NOT NULL
- address_id (배송지 아이디) — Foreign key → address.id — NOT NULL
- user_id (유저 아이디) — Foreign key → User.id — NOT NULL
- id (PK2) — Foreign key → address.user_id — NOT NULL
- order_date (주문날짜)
- main_product_name (대표상품)
- total_quentity (전체수량)
- total_price (전체가격)
Password (비밀번호)
- id (PK) — Foreign key → User.id — NOT NULL
- password (비밀번호)
- updated_at (변경일)
Product (제품)
- id (PK) — Primary key — NOT NULL
- name (제품명)
- price (가격)
Stock (재고)
- id (PK) — Foreign key → Product.id — NOT NULL
- stock (재고)
User (유저)
- id (PK) — Primary key — NOT NULL
- user_id (유저 아이디)
- name (이름)
- birthday (생일)
- contact (연락처)
- isDeleted (삭제여부)
- deleted_at (삭제일)
address (주소)
- id (Key) — Primary key — NOT NULL
- user_id (유저아이디) — Foreign key → User.id — NOT NULL
- locate (배송지)
deletedUser (비활성유저)
- id (PK) — Primary key — NOT NULL
- userId (유저 아이디)
- pwd (비밀번호)
- name (이름)
- birthday (생일)
- contact (연락처)