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