products

테이블 (4)

Accounts (계정) (accounts)

  • Account ID (계정 ID) (id) — INT — 기본 키 — NOT NULL
  • Password Hash (비밀번호 해시) (password) — VARCHAR(256)
  • OAuth Token (OAuth 토큰) (oauth_token) — VARCHAR(256)
  • Email (이메일) (email) — VARCHAR(256)
  • Company (회사) (company) — VARCHAR(128)
  • Name and Job Position (이름과 직책) (job_name) — VARCHAR(64)
  • Phone Number (전화번호) (phone) — VARCHAR(20)
  • Address 1 (주소 1) (address1) — VARCHAR(128)
  • Address 2 (주소 2) (address2) — VARCHAR(128)
  • City (도시) (city) — VARCHAR(64)
  • State/Province (주) (state) — VARCHAR(64)
  • Country (국가) (country) — VARCHAR(64)
  • Date of Company Establishment (기업 설립일) (date_of_estab) — DATE
  • Company Website (회사 웹사이트) (website) — VARCHAR(128)
  • Business Type (사업 종류: 면세 사업자 등) (business_type) — VARCHAR(8)
  • Language (언어) (language) — VARCHAR(32)
  • Time Zone (시간대) (time_zone) — VARCHAR(32)
  • Buyer (구매 회원 여부) (buyer) — INT(1)
  • Seller (판매 회원 여부) (sellerB) — INT(1)

Buy Quantities (구매 수량) (buy_quantities)

  • Buy ID (구매 ID) (id) — INT — 기본 키 — NOT NULL
  • Buyer ID (구매자 ID) (buyer_id) — INT — 외래 키 → Accounts (계정).Account ID (계정 ID) — NOT NULL
  • Sell ID (판매 ID) (sell_id) — INT — 외래 키 → Sell Quantities (판매 수량).Sell ID (판매 ID) — NOT NULL
  • Quantity (수량) (quantity) — INT
  • Registration Time (등록 시각) (created_at) — Timestamp

Products (상품 정보) (products)

  • Product ID (상품 ID) (id) — INT — 기본 키 — NOT NULL
  • Product Code (상품코드) (code) — VARCHAR(256)
  • Product Name (상품이름) (name) — VARCHAR(128)
  • Brand Name (브랜드) (brand) — VARCHAR(128)
  • Category (카테고리) (category) — VARCHAR(128)
  • Gender (성별) (gender) — VARCHAR(8)
  • Status (상태) (status) — VARCHAR(32)
  • Season (시즌) (season) — VARCHAR(8)
  • Price (가격) (price) — INT
  • Discounted Price (할인가) (discounted_price) — INT
  • Discount % (할인율) (discount_percent) — INT
  • Product Description (상품설명) (description) — TEXT
  • Hash Tags (해시태그) (hash_tags) — VARCHAR(256)
  • Search Keywords (검색 키워드) (keywords) — VARCHAR(256)
  • Color (색상) (color) — VARCHAR(16)
  • Manufacturer (제조사) (manufacturer) — VARCHAR(128)
  • Purchase Conditions (구매조건) (purchase_conditions) — TEXT
  • Country of Origin (원산지) (origin) — VARCHAR(64)
  • Material (소재) (material) — VARCHAR(64)
  • Image 1 (이미지1) (image1) — VARCHAR(128)
  • Image 2 (이미지2) (image2) — VARCHAR(128)
  • Image 3 (이미지3) (image3) — VARCHAR(128)
  • Image 4 (이미지4) (image4) — VARCHAR(128)

Sell Quantities (판매 수량) (sell_quantities)

  • Sell ID (판매 ID) (id) — INT — 기본 키 — NOT NULL
  • Product ID (상품 ID) (product_id) — INT — 외래 키 → Products (상품 정보).Product ID (상품 ID) — NOT NULL
  • Seller ID (판매자 ID) (seller_id) — INT — 외래 키 → Accounts (계정).Account ID (계정 ID) — NOT NULL
  • Product Size (상품 사이즈) (size) — VARCHAR(8)
  • Quantity (수량) (quantity) — INT
  • Registration Time (등록 시각) (created_at) — Timestamp