goodsellingserver
Tables (3)
order (장바구니)
- id (장바구니 고유번호) — bigint — Primary key — NOT NULL
- user_id (회원고유번호) — bigint — Foreign key → user.id — NOT NULL
- id (상품 고유번호) — bigint — Foreign key → product.id — NOT NULL
- quantity (총 상품 개수) — NOT NULL
- total_price (총 가격) — bigint — NOT NULL
- created_at (Field) — timestamp — NOT NULL
product (상품)
- id (상품고유번호) — bigint — Primary key — NOT NULL
- product_name (상품명) — varchar(100) — NOT NULL
- price (가격) — bigint — NOT NULL
- stock (수량) — bigint — NOT NULL
- description (상품설명) — varchar(255) — NOT NULL
- category (카테고리) — ENUM('CLOTH', 'FOOD'" — NOT NULL
user (회원)
- id (회원고유번호) — bigint — Primary key — NOT NULL
- email (이메일) — varchar(25) — NOT NULL
- password (비밀번호) — varchar(100) — NOT NULL
- gender (성별) — char(1) — NOT NULL
- phone (전화번호) — varchar(13) — NOT NULL
- address (주소) — varchar(100) — NOT NULL
- role (ENUM('ADMIN', 'USER')) — varchar(10) — NOT NULL
- created_at (Field) — timestamp — NOT NULL