DD

Tables (19)

article

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • content — text
  • title — varchar(200)
  • view — bigint(20)
  • author_id — bigint(20) — Foreign key → site_user.id
  • board_category_id — int(11) — Foreign key → board_category.id
  • cafe — bigint(20) — Foreign key → cafe.id

article_tags

  • tag_id — bigint(20) — Foreign key → tag.id — NOT NULL
  • article_id — bigint(20) — Foreign key → article.id — NOT NULL

article_voter

  • voter_id — bigint(20) — Foreign key → site_user.id — NOT NULL
  • article_id — bigint(20) — Foreign key → article.id — NOT NULL

board_category

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(200)
  • cafe_id — bigint(20) — Foreign key → cafe.id

cafe

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • intro — text
  • name — varchar(50)
  • profile_img — varchar(255)
  • author_id — bigint(20) — Foreign key → site_user.id
  • category_id — smallint(6) — Foreign key → category.id
  • manager_id — bigint(20) — Foreign key → site_user.id — NOT NULL

cafe_voter

  • cafe_id — bigint(20) — Foreign key → cafe.id — NOT NULL
  • voter_id — bigint(20) — Foreign key → site_user.id — NOT NULL

category

  • id — smallint(6) — Primary key — NOT NULL
  • created_date — datetime(6)
  • major_category — varchar(50)
  • minor_category — varchar(50)
  • modified_date — datetime(6)
  • author_id — bigint(20) — Foreign key → site_user.id

comment

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • content — text
  • article_id — bigint(20) — Foreign key → article.id
  • author_id — bigint(20) — Foreign key → site_user.id
  • notice_id — bigint(20) — Foreign key → notice.id
  • suggestion_id — bigint(20) — Foreign key → suggestion.id

comment_voter

  • comment_id — bigint(20) — Foreign key → comment.id — NOT NULL
  • voter_id — bigint(20) — Foreign key → site_user.id — NOT NULL

notice

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • content — text
  • title — varchar(200)
  • view — bigint(20)
  • author_id — bigint(20) — Foreign key → site_user.id
  • cafe_id — bigint(20) — Foreign key → cafe.id

notice_voter

  • notice_id — bigint(20) — Foreign key → notice.id — NOT NULL
  • voter_id — bigint(20) — Foreign key → site_user.id — NOT NULL

site_user

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • address — varchar(2000)
  • email — varchar(255)
  • intro — varchar(255)
  • nickname — varchar(255)
  • password — varchar(255)
  • profile_img — varchar(255)
  • cafe_id — bigint(20)

site_user_cafe

  • cafe_id — bigint(20) — Foreign key → cafe.id — NOT NULL
  • site_user_id — bigint(20) — Foreign key → site_user.id — NOT NULL

site_user_neighbor

  • site_user_id — bigint(20) — Foreign key → site_user.id — NOT NULL
  • neighbor_id — bigint(20) — Foreign key → site_user.id — NOT NULL

siteuser_roles

  • siteuser_id — bigint(20) — Foreign key → site_user.id — NOT NULL
  • roles — enum('ADMIN','MANAGER','USER')

suggestion

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • content — text
  • title — varchar(200)
  • view — bigint(20)
  • author_id — bigint(20) — Foreign key → site_user.id
  • cafe_id — bigint(20) — Foreign key → cafe.id

suggestion_comment

  • id — bigint(20) — Primary key — NOT NULL
  • created_date — datetime(6)
  • modified_date — datetime(6)
  • content — text
  • suggestion_id — bigint(20)
  • title — varchar(200)
  • author_id — bigint(20) — Foreign key → site_user.id
  • cafe_id — bigint(20) — Foreign key → cafe.id

suggestion_voter

  • suggestion_id — bigint(20) — Foreign key → suggestion.id — NOT NULL
  • voter_id — bigint(20) — Foreign key → site_user.id — NOT NULL

tag

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