날씨별 _옷

테이블 (8)

Board

  • id (board_id) — Long — 기본 키 — NOT NULL
  • id (member_id) — Long — 외래 키 → Member.id — NOT NULL
  • title — varchar
  • image — varchar

Board_item

  • id (board_item_id) — Long — 기본 키 — NOT NULL
  • id (board_id) — Long — 외래 키 → Board.id — NOT NULL
  • id (item_id) — Long — 외래 키 → Item.id — NOT NULL

Category_Board (Untitled)

  • id (category_board_id) — Long — 기본 키 — NOT NULL
  • id (weather_category_id) — Long — 외래 키 → Weather_category.id — NOT NULL
  • id (board_id) — Long — 외래 키 → Board.id — NOT NULL

Item

  • id (item_id) — Long — 기본 키 — NOT NULL
  • name — varchar
  • price (pirce) — int
  • color — varchar
  • clothingType — varchar
  • update_date — Date
  • create_date — Date

Like

  • id (Like_id) — Long — 기본 키 — NOT NULL
  • id (member_id) — Long — 외래 키 → Member.id — NOT NULL
  • id (board_id) — Long — 외래 키 → Board.id — NOT NULL

Location (location)

  • id (location_id) — Double — 기본 키 — NOT NULL
  • level1 — varchar
  • level2 — varchar
  • level3 — varchar
  • gridX — int
  • gridY — int
  • latitude — double
  • longitude — double

Member

  • id (member_id) — Long — 기본 키 — NOT NULL
  • logon_id (login_id) — String
  • password — varchar
  • gender — varchar
  • height — float
  • weight — float
  • bodyType — varchar
  • update_date — Date
  • create_date — Date

Weather_category

  • id (weather_category_id) — Long — 기본 키 — NOT NULL
  • name — varchar