day-mood
Tables (3)
Likes (좋아요)
- likes_id (PK) — NOTNULL — Primary key — NOT NULL
- user_id (PK2) — NOTNULL — Foreign key → User.user_id — NOT NULL
- post_id (PK3) — NOTNULL — Foreign key → Post.post_id — NOT NULL
- ... — ...
Post (게시물)
- post_id (PK) — NOTNULL — Primary key — NOT NULL
- user_id (PK2) — NOTNULL — Foreign key → User.user_id — NOT NULL
- content (Field) — NOTNULL
- like_count (Field2) — NOTNULL
User (회원)
- user_id (PK) — NOTNULL — Primary key — NOT NULL
- username (Field) — NOTNULL
- password (Field2) — NOTNULL
- nickname (Field3) — NOTNULL
- role (Field4) — NOTNULL
- ... — ...