HW KMS ERD
Tables (22)
CATEGORY
- category_id — long — Primary key — NOT NULL
- name — varchar
CHAT
- chat_id — long — Primary key — NOT NULL
- content — varchar
- create_dt — date
- chat_room_id — long — Foreign key → CHAT_ROOM.chat_room_id — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
CHAT_ROOM
- chat_room_id — long — Primary key — NOT NULL
- name — varchar
CHAT_ROOM_USER
- chat_room_user_id — long — Primary key — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
- chat_room_id — long — Foreign key → CHAT_ROOM.chat_room_id — NOT NULL
FOLLOW
- follow_id — long — Primary key — NOT NULL
- follower_id — long — Foreign key → USER.user_id — NOT NULL
- followee_id — long — Foreign key → USER.user_id — NOT NULL
POST
- post_id — long — Primary key — NOT NULL
- title — varchar
- content — varchar
- create_dt — date
- table_id — long — Foreign key → TABLE.table_id — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
POST_LIKE
- post_like_id — long — Primary key — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
- post_id — long — Foreign key → POST.post_id — NOT NULL
POST_STAR
- post_star_id — long — Primary key — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
- post_id — long — Foreign key → POST.post_id — NOT NULL
REPLY
- reply_id — long — Primary key — NOT NULL
- content — varchar
- create_dt — date
- post_id — long — Foreign key → POST.post_id — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
REPLY_LIKE
- reply_like_id — long — Primary key — NOT NULL
- reply_id — long — Foreign key → REPLY.reply_id — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
ROLE
- role_id — int — Primary key — NOT NULL
- role — varchar
SEARCH_LOG
- search_log_id — long — Primary key — NOT NULL
- content — varchar
- create_dt — date
- user_id — long — Foreign key → USER.user_id — NOT NULL
TABLE
- table_id — long — Primary key — NOT NULL
- name — varchar
- desc — varchar
- create_dt — date
- is_public — boolean
TABLE_USER
- tablie_user_id (table_user_id) — long — Primary key — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
- table_id — long — Foreign key → TABLE.table_id — NOT NULL
- is_admin — boolean
- accept — boolean
TAG
- tag_id — long — Primary key — NOT NULL
- name — varchar
TAG_POST
- tag_post_id — long — Primary key — NOT NULL
- post_id — long — Foreign key → POST.post_id — NOT NULL
- tag_id — long — Foreign key → TAG.tag_id — NOT NULL
USER
- user_id — long — Primary key — NOT NULL
- user_name — varchar
- password — varchar
- email — varchar
- position — varchar
USER_ROLE
- user_role_id — long — Primary key — NOT NULL
- user_id (uesr_id) — long — Foreign key → USER.user_id — NOT NULL
- role_id — int — Foreign key → ROLE.role_id — NOT NULL
WIKI
- wiki_id — long — Primary key — NOT NULL
- title — varchar
- content — varchar
- create_dt — varchar
- table_id — long — Foreign key → TABLE.table_id — NOT NULL
- category_id — long — Foreign key → CATEGORY.category_id — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
WIKI_LIKE
- wiki_like_id — long — Primary key — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
- wiki_id — long — Foreign key → WIKI.wiki_id — NOT NULL
WIKI_LOG
- wiki_log_id — long — Primary key — NOT NULL
- title — varchar
- content — varchar
- update_dt — date
- wiki_id — long — Foreign key → WIKI.wiki_id — NOT NULL
WIKI_STAR
- wiki_star_id — long — Primary key — NOT NULL
- user_id — long — Foreign key → USER.user_id — NOT NULL
- wiki_id — long — Foreign key → WIKI.wiki_id — NOT NULL