날씨별 _옷
테이블 (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