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)