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)