whats_hot

Tables (16)

_file

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • domain — enum('MEMBER','SPOT','REVIEW')
  • ext — varchar(255)
  • name — varchar(255)
  • size — bigint(20)
  • uuid — varchar(255)

category

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • depth — int(11)
  • name — varchar(255)
  • parent_id — bigint(20) — Foreign key → category.id

comment

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • content — varchar(255)
  • liked — bigint(20)
  • author_id — bigint(20) — Foreign key → member.id
  • review_id — bigint(20) — Foreign key → review.id
  • tag_id — bigint(20) — Foreign key → comment.id

comment_liked_member

  • liked_member_id — bigint(20) — Foreign key → member.id — NOT NULL
  • comment_id — bigint(20) — Foreign key → comment.id — NOT NULL

hashtag

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • name — varchar(255)

member

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • email — varchar(255)
  • is_logout — bit(1) — NOT NULL
  • member_status — enum('ACTIVE','INACTIVE','ARCHIVED','PROHIBITED')
  • password — varchar(255)
  • username — varchar(255)

member_authorities

  • member_id — bigint(20) — Foreign key → member.id — NOT NULL
  • authorities — enum('ADMIN','USER')

member_image

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • image_id — bigint(20) — Foreign key → _file.id
  • member_id — bigint(20) — Foreign key → member.id

menu_item

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • name — varchar(255)
  • price — varchar(255)
  • spot_id — bigint(20) — Foreign key → spot.id

review

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • content — varchar(255)
  • liked — bigint(20)
  • score — double
  • status — enum('DRAFT','PUBLIC','PRIVATE')
  • title — varchar(255)
  • validated — bit(1) — NOT NULL
  • visit_date — datetime(6)
  • author_id — bigint(20) — Foreign key → member.id
  • spot_id — bigint(20) — Foreign key → spot.id

review_hashtag

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • hashtag_id — bigint(20) — Foreign key → hashtag.id
  • review_id — bigint(20) — Foreign key → review.id

review_image

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • image_id — bigint(20) — Foreign key → _file.id
  • review_id — bigint(20) — Foreign key → review.id

review_liked_member

  • liked_member_id — bigint(20) — Foreign key → member.id — NOT NULL
  • review_id — bigint(20) — Foreign key → review.id — NOT NULL

spot

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • address — varchar(255)
  • average_score — double
  • contact — varchar(255)
  • latitude — double
  • longitude — double
  • name — varchar(255)
  • category_id — bigint(20) — Foreign key → category.id

spot_hashtag

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • hashtag_id — bigint(20) — Foreign key → hashtag.id
  • spot_id — bigint(20) — Foreign key → spot.id

spot_image

  • id — bigint(20) — Primary key — NOT NULL
  • create_date — datetime(6)
  • modify_date — datetime(6)
  • image_id — bigint(20) — Foreign key → _file.id
  • spot_id — bigint(20) — Foreign key → spot.id