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