snapbid

Tables (7)

acc (Untitled6)

  • id (PK) — int — Primary key — NOT NULL
  • name (이름) — String — NOT NULL
  • description (설명) — String — NOT NULL
  • file_path (파일경로) — String — NOT NULL
  • file_name (파일명) — String — NOT NULL

desktop (Untitled4)

  • id (PK) — int — Primary key — NOT NULL
  • CPU — String — NOT NULL
  • GPU — String — NOT NULL
  • SSD — String
  • HDD — String
  • RAM1 — String — NOT NULL
  • RAM2 — String
  • RAM3 — String
  • RAM4 — String
  • mainboard (메인보드) — String — NOT NULL
  • power (파워) — String — NOT NULL
  • description (설명) — String
  • file_path (파일경로) — String — NOT NULL
  • file_name (파일명) — String — NOT NULL

laptop (Untitled3)

  • id (PK) — int — Primary key — NOT NULL
  • brand (브랜드) — String — NOT NULL
  • name (이름) — String — NOT NULL
  • SSD (저장소) — String — NOT NULL
  • CPU — String — NOT NULL
  • GPU — String — NOT NULL
  • RAM — String — NOT NULL
  • inch (화면 크기) — String — NOT NULL
  • color (색상) — String — NOT NULL
  • description (설명) — String
  • file_path (파일 경로) — String — NOT NULL
  • file_name (파일명) — String — NOT NULL

phone (Untitled5)

  • id (PK) — int — Primary key — NOT NULL
  • brand (브랜드) — String — NOT NULL
  • name (이름) — String — NOT NULL
  • inch (화면 크기) — String — NOT NULL
  • storage (저장소) — String — NOT NULL
  • color (색상) — String — NOT NULL
  • description (설명) — String
  • file_path (파일경로) — String — NOT NULL
  • file_name (파일명) — String — NOT NULL

product_code (Untitled7)

  • id (PK) — int — Primary key — NOT NULL
  • brand (브랜드) — String — NOT NULL
  • name (제품명) — String — NOT NULL

sale (Untitled2)

  • id (PK) — int — Primary key — NOT NULL — 제품 테이블의 ID를 외래키로 참조
  • product_id (int) — int — NOT NULL
  • start_price (최초 판매가) — String — NOT NULL
  • bid_price (현재 입찰가) — String
  • start_date (등록일) — dateTime — NOT NULL
  • end_date (마감일) — dateTime — NOT NULL
  • origin_price (발매가) — String

users (Untitled)

  • id (Key) — int — Primary key — NOT NULL — Auto increment
  • email (이메일) — VARCHAR(255) — NOT NULL
  • pwd (비밀번호) — VARCHAR(255) — NOT NULL
  • phone (전화번호) — VARCHAR(255) — NOT NULL
  • birth (생년월일) — VARCHAR(255) — NOT NULL
  • deleted (탈퇴 유저) — boolean