meme

Tables (8)

Member (멤버)

  • member_id (멤버 아이디) — bigint — Primary key — NOT NULL
  • login_id (로그인 아이디) — varchar
  • nickname (별명) — varchar
  • password (비밀번호) — varchar
  • email (이메일) — varchar
  • created_dt (생성일) — datetime(6)
  • updated_dt (수정일) — datetime(6)

Meme (밈)

  • meme_id (밈 아이디) — bigint — Primary key — NOT NULL
  • member_id (멤버 아이디) — bigint — Foreign key → Member.member_id — NOT NULL
  • title (제목) — varchar
  • body (내용) — varchar
  • views (조회수) — bigint
  • score (스코어) — int
  • created_dt (생성일) — datetime(6)
  • updated_dt (수정일) — datetime(6)

MemeComent (밈 코멘트)

  • meme_comment_id (Key) — bigint — Primary key — NOT NULL
  • meme_id (밈 아이디) — bigint — Foreign key → Meme.meme_id — NOT NULL
  • member_id (멤버 아이디) — bigint — Foreign key → Member.member_id — NOT NULL
  • body (내용) — varchar
  • created_dt (생성일) — datetime(6)
  • updated_dt (수정일) — datetime(6)

MemeCommentLike (밈 코멘트 좋아요)

  • meme_comment_like_id (밈 코멘트 좋아요 아이디) — bigint — Primary key — NOT NULL
  • meme_comment_id (Key) — bigint — Foreign key → MemeComent.meme_comment_id — NOT NULL
  • member_id (멤버 아이디) — bigint — Foreign key → Member.member_id — NOT NULL
  • created_dt (생성일) — datetime(6)
  • updated_dt (수정일) — datetime(6)

MemeLike (밈 좋아요)

  • meme_like_id (밈 좋아요 아이디) — bigint — Primary key — NOT NULL
  • meme_id (밈 아이디) — bigint — Foreign key → Meme.meme_id — NOT NULL
  • member_id (멤버 아이디) — bigint — Foreign key → Member.member_id — NOT NULL
  • created_dt (생성일) — datetime(6)
  • updated_dt (수정일) — datetime(6)

MemeTag (밈태그)

  • meme_tag_id (Key) — Primary key — NOT NULL
  • meme_id (밈 아이디) — bigint — Foreign key → Meme.meme_id — NOT NULL
  • tag_id (태그 아이디) — bigint — Foreign key → Tag.tag_id — NOT NULL

Session (세션)

  • session_id (세션 아이디) — varchar — Primary key — NOT NULL
  • member_id (멤버 아이디) — bigint — Foreign key → Member.member_id — NOT NULL
  • created_dt (생성일) — datetime(6)
  • updated_dt (수정일) — datetime(6)

Tag (태그)

  • tag_id (태그 아이디) — bigint — Primary key — NOT NULL
  • meme_id (밈 아이디) — bigint — Foreign key → Meme.meme_id — NOT NULL
  • title (제목) — varchar
  • created_dt (생성일) — datetime(6)
  • updated_dt (수정일) — datetime(6)