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)