fleaMarket

테이블 (8)

Untitled (location)

  • Key (location_idx) — int — 기본 키 — NOT NULL
  • Field (location) — string — NOT NULL
  • Field (delete_date) — date

Untitled (image)

  • Key (image_idx) — int — 기본 키 — NOT NULL
  • 물품 id (item_idx) — int — 외래 키 → 판매물품.물품 id — NOT NULL
  • Field (delete_date) — date

Untitled (locationlist)

  • Key (location_idx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_idx) — int — 외래 키 → 유저.Key — NOT NULL
  • Field (is_select) — boolean — NOT NULL
  • Field (delete_date) — date

Untitled (category)

  • Key (category_idx) — int — 기본 키 — NOT NULL
  • Field (category) — string — NOT NULL
  • Field (delete_date) — date

Untitled (item_state)

  • Key (state_idx) — int — 기본 키 — NOT NULL
  • Field (state) — string — NOT NULL
  • Field (delete_date) — date

관심목록 (attention)

  • 물품 id (item_idx) — int — 외래 키 → 판매물품.물품 id — NOT NULL
  • Key (user_idx) — int — 외래 키 → 유저.Key — NOT NULL
  • 등록일자 (create_date) — date — NOT NULL
  • Field (delete_date) — date

유저 (user)

  • Key (user_idx) — int — 기본 키 — NOT NULL
  • 유저 id (user_id) — string — NOT NULL
  • 비밀번호 (password) — string — NOT NULL
  • salt — string — NOT NULL
  • 가입일 (create_date) — date — NOT NULL
  • 리프레쉬 토큰 (refresh) — string
  • Field (github_login) — string
  • Field (delete_date) — date

판매물품 (item)

  • 물품 id (item_idx) — int — 기본 키 — NOT NULL
  • Field (item) — string — NOT NULL
  • 가격 (price) — int — NOT NULL
  • 등록일자 (post_date) — date — NOT NULL
  • Field (content) — string
  • Key (location_idx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (category_idx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (state_idx) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_idx) — int — 외래 키 → 유저.Key — NOT NULL
  • Field (delete_date) — date