basesite
Tables (9)
Carts (장바구니)
- cartNo (장바구니번호) — INT — Primary key — NOT NULL
- userNo (유저번호) — INT — Foreign key → Users.userNo — NOT NULL
- productNo (상품번호) — INT — Foreign key → Products.productNo — NOT NULL
- date (추가날짜) — TIMESTAMP — NOT NULL
- quantity (수량) — INT — NOT NULL
Coupons (쿠폰)
- couponNo (쿠폰번호) — INT — Primary key — NOT NULL
- userNo (유저번호) — INT — Foreign key → Users.userNo — NOT NULL
- name (이름) — VARCHAR(255) — NOT NULL
- type (쿠폰 종류) — VARCHAR(50) — NOT NULL
- value (가치) — INT — NOT NULL
- expireDate (만료기간) — DATE — NOT NULL
- state (상태) — INT — NOT NULL
FAQS (자주하는질문)
- faqNo (질문번호) — INT — Primary key — NOT NULL
- category (카테고리) — VARCHAR(50) — NOT NULL
- title (제목) — VARCHAR(50) — NOT NULL
- content (내용) — TEXT — NOT NULL
Orders (작업)
- orderNo (작업번호) — INT — Primary key — NOT NULL
- payNo (결제번호) — INT — Foreign key → Payments.payNo — NOT NULL
- userNo (유저번호) — INT — Foreign key → Payments.userNo — NOT NULL
- date (작업 날짜) — DATETIME — NOT NULL
- content (내용) — TEXT — NOT NULL
- state (상태) — VARCHAR(50) — NOT NULL
Payments (결제)
- payNo (결제번호) — INT — Primary key — NOT NULL
- userNo (유저번호) — INT — Foreign key → Users.userNo — NOT NULL
- productNo (상품번호) — INT — Foreign key → Products.productNo
- couponNo (쿠폰번호) — INT — Foreign key → Coupons.couponNo
- date (결제날짜) — TIMESTAMP — NOT NULL
- price (가격) — INT — NOT NULL
- quantity (수량) — INT — NOT NULL
- state (상태) — VARCHAR(50) — NOT NULL
- payType (결제종류) — VARCHAR(50) — NOT NULL
- payName (결제자 이름) — VARCHAR(50)
- bootpayNo (부트페이 결제 번호) — VARCHAR(255)
- taxNo (세금 번호) — VARCHAR(50)
- taxCompany (세금 회사 이름) — VARCHAR(50)
- taxName (세금 이름) — VARCHAR(50)
- taxEmail (세금 이메일) — VARCHAR(100)
- taxType (세금 종류) — VARCHAR(50)
- taxState (세금 상태) — VARCHAR(50)
- parentsNo (부모결제번호) — INT — Foreign key → Payments.payNo
- usedPoint (사용포인트) — INT
Posts (게시글)
- postNo (게시글 번호) — INT — Primary key — NOT NULL
- userNo (유저번호) — INT — Foreign key → Users.userNo — NOT NULL
- date (생성날짜) — TIMESTAMP — NOT NULL
- category (카테고리) — VARCHAR(50) — NOT NULL
- title (제목) — VARCHAR(50) — NOT NULL
- content (내용) — TEXT — NOT NULL
- views (조회수) — INT — NOT NULL
Products (상품)
- productNo (상품번호) — INT — Primary key — NOT NULL
- code (상품코드) — VARCHAR(20) — NOT NULL
- title (제목) — VARCHAR(50) — NOT NULL
- content (내용) — TEXT — NOT NULL
- image (이미지) — VARCHAR(255)
- quantity (수량) — INT — NOT NULL
- price (가격) — INT — NOT NULL
Reviews (리뷰)
- reviewNo (리뷰 번호) — INT — Primary key — NOT NULL
- payNo (결제번호) — INT — Foreign key → Payments.payNo — NOT NULL
- userNo (유저번호) — INT — Foreign key → Users.userNo — NOT NULL
- date (생성날짜) — TIMESTAMP — NOT NULL
- rating (별점) — DECIMAL(3, 1) — NOT NULL
- title (제목) — VARCHAR(50) — NOT NULL
- content (내용) — TEXT — NOT NULL
Users (유저)
- userNo (유저번호) — INT — Primary key — NOT NULL
- username (유저아이디) — VARCHAR(50) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL
- email (이메일) — VARCHAR(100) — NOT NULL
- phone (휴대폰번호) — VARCHAR(20) — NOT NULL
- point (포인트) — INT — NOT NULL
- loginMethod (로그인방식) — VARCHAR(20) — NOT NULL
- createdAt (생성일자) — TIMESTAMP — NOT NULL
- level (유저상태) — INT — NOT NULL
- ref (추천인) — VARCHAR(50)
- APIKey (API키) — VARCHAR(255)
- refreshToken (리프레시 토큰) — VARCHAR(255)
- taxNo (세금 번호) — VARCHAR(50)
- taxCompany (세금 회사 이름) — VARCHAR(50)
- taxName (세금 이름) — VARCHAR(50)
- taxEmail (세금 이메일) — VARCHAR(100)