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