FindMyMeme
Tables (13)
COMMENT
- id — BIGINT — Primary key — NOT NULL
- content — VARCHAR — NOT NULL
- parent_comment_id — BIGINT — Foreign key → COMMENT.id
- find_post_id — BIGINT — Foreign key → FIND_POST.id — NOT NULL
- id (id2) — BIGINT — Foreign key → USER.id — NOT NULL
- html_content — TEXT — NOT NULL
COMMENT_IMAGE
- id — BIGINT — Primary key — NOT NULL
- imageUrl — VARCHAR — NOT NULL
- original_filename (original_filenmae) — VARCHAR — NOT NULL
- comment_id — BIGINT — Foreign key → COMMENT.id — NOT NULL
FILE_META
- id — BIGINT — Primary key — NOT NULL
- original_filename — VARHCAR — NOT NULL
- image_url — VARCHAR — NOT NULL
- size — BIGINT — NOT NULL
- statue (stutus) — VARCHAR — NOT NULL
FIND_POST
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR — NOT NULL
- content — TEXT — NOT NULL
- status — NOT NULL
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- html_content — TEXT — NOT NULL
FIND_POST_IMAGE
- id — BIGINT — Primary key — NOT NULL
- imageUrl — VARCHAR — NOT NULL
- find_post_id — BIGINT — Foreign key → FIND_POST.id — NOT NULL
- original_filename (original_filenmae) — VARCHAR — NOT NULL
MEME_META
- id — BIGINT — Primary key — NOT NULL
- imageUrl — VARCHAR — NOT NULL
- 확장자 (extension) — VARCHAR
- height — INT
- weight — INT
- size — BIGINT
- original_filename — VARCHAR — NOT NULL
MEME_POST
- id — BIGINT — Primary key — NOT NULL
- meme_id — BIGINT — Foreign key → MEME_META.id — NOT NULL
- user_id (usr_id) — BIGINT — Foreign key → USER.id — NOT NULL
- like_count — BIGINT — NOT NULL
- view_count — BIGINT — NOT NULL
- imageUrl — VARCHAR — NOT NULL
MEME_POST_LIKE
- id — BIGINT — Primary key — NOT NULL
- meme_post_id — BIGINT — Foreign key → MEME_POST.id — NOT NULL — unique(user_id, meme_post_id)
- user_id (usre_id) — BIGINT — Foreign key → USER.id — NOT NULL — unique(user_id, meme_post_id)
POST_TAG
- id — BIGINT — Primary key — NOT NULL
- post_type — VARCHAR — NOT NULL — unique(post_type, post_id, tag_id)
- tag_id — BIGINT — Foreign key → TAG.id — NOT NULL — unique(post_type, post_id, tag_id)
- post_id — BIGINT — NOT NULL — unique(post_type, post_id, tag_id)
ROLE
- id — BIGINT — Primary key — NOT NULL
- role_type — VARCHAR — NOT NULL — unique
TAG
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR
- parent_tag_id — BIGINT
- Field
USER
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR — NOT NULL — unique
- email — VARCHAR — NOT NULL
- password — VARCHAR — NOT NULL
USER_ROLE
- id — BIGINT — Primary key — NOT NULL
- Field
- user_id — BIGINT — Foreign key → USER.id — NOT NULL
- role_id — BIGINT — Foreign key → ROLE.id — NOT NULL