TripCafe
Tables (6)
Address (address)
- id (address_id) — Long — Primary key — NOT NULL
- city — String
- street — String
- zipcode — String
Board (board)
- id (board_id) — Long — Primary key — NOT NULL
- title — String
- content — String
- Field
- member (member_id) — Long — Foreign key → Member.id — NOT NULL
Cafe (cafe)
- id (cafe_id) — Long — Primary key — NOT NULL
- name (cafe_name) — String
- nickname — String
- tags — List
- address — Long — Foreign key → Address.id — NOT NULL
CafeSummarize (cafe_summarize)
- id (cafe_summarize_id) — Long — Primary key — NOT NULL
- tag (tag_id) — Long — Foreign key → Tag.id — NOT NULL
- cafe (cafe_id) — Long — Foreign key → Cafe.id — NOT NULL
Member (member)
- id (member_id) — Long — Primary key — NOT NULL
- name — varchar(20)
- password — varchar(100)
- nickname — varchar(20)
- address — Long — Foreign key → Address.id — NOT NULL
Tag (tag)
- id (keyword_id) — Long — Primary key — NOT NULL
- tagName (tag_name) — varchar(50)
- cafes — List