togeteat
Tables (8)
Cart (장바구니)
- cart_id — VARCHAR(20) — Primary key — NOT NULL
- shop_id — VARCHAR(200) — Foreign key → Shop.shop_id — NOT NULL
- user_id — INT UNSIGNED — Foreign key → User.userid — NOT NULL
- product_id — VARCHAR(50) — Foreign key → Shop.product_id — NOT NULL
- price (가격) — INT UNSIGNED — NOT NULL
- total_price (총 주문금액) — INT UNSIGNED — NOT NULL
- photo (사진) — VARCHAR(100)
Order (주문기록)
- id (order_id) — VARCHAR(100) — Primary key — NOT NULL
- userid (user_id) — VARCHAR(20) — Foreign key → User.userid — NOT NULL
- shop_id — VARCHAR(20) — Foreign key → Shop.shop_id — NOT NULL
- product_id — VARCHAR(50) — Foreign key → Shop.product_id — NOT NULL
- receive_name (받는 고객) — VARCHAR(30) — NOT NULL
- receive_address (받는 고객주소) — VARCHAR(100) — NOT NULL
- receive_tel (받는 고객전화번호) — VARCHAR(11) — NOT NULL
- order_state (주문상태) — ENUM — NOT NULL
- delivered_time (배송 완료시간(예상)) — VARCHAR(20) — NOT NULL
- delivered_state (배송 상태) — ENUM — NOT NULL
- order_count (주문 횟수) — VARCHAR(100) — NOT NULL
Pay (결제기록)
- pay_id — VARCHAR(100) — Primary key — NOT NULL
- userid (user_id) — VARCHAR(20) — Foreign key → User.userid — NOT NULL
- Field (결제 수단) — ENUM — NOT NULL
- pay_time (결제 시간) — DATETIME — NOT NULL
- total_price (총 주문 금액) — INT UNSIGNED — NOT NULL
- delivered_price (배송비) — INT UNSIGNED — NOT NULL
- discount_price (할인 금액) — INT UNSIGNED — NOT NULL
- final_price (최종 금액) — INT UNSIGNED — NOT NULL
- point (포인트) — INT UNSIGNED — NOT NULL
- save_point (포인트 적립 내역) — INT UNSIGNED — NOT NULL
- use_point (포인트 사용 내역) — INT — NOT NULL
Product (상품)
- product_id — VARCHAR(50) — Primary key — NOT NULL
- product_name (상품 이름) — VARCHAR(50) — NOT NULL
- product_content (상품 정보) — VARCHAR(200) — NOT NULL
- photo (사진) — VARCHAR(100)
- stock (재고) — SMALLINT UNSIGNED — NOT NULL
Recommend (추천)
- recommend_id — VARCHAR(100) — Primary key — NOT NULL
- userid (user_id) — VARCHAR(20) — Foreign key → User.userid — NOT NULL
- shop_id — VARCHAR(20) — Foreign key → Shop.shop_id — NOT NULL
- product_id — VARCHAR(50) — Foreign key → Shop.product_id — NOT NULL
- date (주문날짜) — DATE
- area (지역) — VARCHAR(50)
- city (도시) — VARCHAR(50)
- age (나이) — INT UNSIGNED
- gender (성별) — ENUM
- category (카테고리) — ENUM
- order_count (주문횟수) — VARCHAR(100)
Review (리뷰)
- review_id — VARCHAR(100) — Primary key — NOT NULL
- userid (user_id) — VARCHAR(20) — Foreign key → User.userid — NOT NULL
- title (제목) — VARCHAR(20) — NOT NULL
- content (내용) — VARCHAR(500) — NOT NULL
- grade (별점) — ENUM
- date (날짜) — DATE — NOT NULL
- photo (사진) — VARCHAR(100)
- nickname (닉네임) — VARCHAR(20)
Shop (가게)
- shop_id — VARCHAR(20) — Primary key — NOT NULL
- product_id — VARCHAR(50) — Foreign key → Product.product_id — NOT NULL
- password (비밀번호) — CHAR(60) — NOT NULL
- name (가게 이름) — VARCHAR(30) — NOT NULL
- address (주소) — VARCHAR()(100) — NOT NULL
- businessnumber (사업자번호) — VARCHAR(12) — NOT NULL
- shoptel (가게전화번호) — VARCHAR(13) — NOT NULL
- category (카테고리) — ENUM — NOT NULL
User (유저)
- userid (user_id) — VARCHAR(20) — Primary key — NOT NULL
- name (이름) — VARCHAR(10) — NOT NULL
- password (비밀번호) — VARCHAR(20) — NOT NULL
- nickname (닉네임) — VARCHAR(20) — NOT NULL
- email (이메일) — VARCHAR(30)
- tel (전화번호) — VARCHAR(11) — NOT NULL
- address (주소) — VARCHAR(100) — NOT NULL
- birth (셩년월일) — DATE — NOT NULL
- gender (성별) — ENUM — NOT NULL
- category (카테고리) — ENUM