dream
Tables (5)
Comment (댓글)
- comment_id (PK) — NOTNULL — Primary key — NOT NULL
- user_id (FK) — NOTNULL — Foreign key → User.user_id — NOT NULL
- post_id (FK2) — NOTNULL — Foreign key → Post.post_id — NOT NULL
- content (Field) — NOTNULL
- created_at (Field2) — NOTNULL
- updated_at (Field3) — NULL
- parent_id (FK3) — NULL — Foreign key → Comment.comment_id — NOT NULL
Follow (팔로우)
- follow_id (PK) — NOTNULL — Primary key — NOT NULL
- follow_user_id (FK) — NOTNULL — Foreign key → User.user_id — NOT NULL
- created_at (Field2) — NOTNULL
- updated_at (Field3) — NULL
- following_user_id (FK2) — NOTNULL — Foreign key → User.user_id — NOT NULL
Like (좋아요)
- like_id (PK) — NOTNULL — Primary key — NOT NULL
- user_id (FK) — NOTNULL — Foreign key → User.user_id — NOT NULL
- post_id (FK2) — NOTNULL — Foreign key → Post.post_id — NOT NULL
- created_at (Field2) — NOTNULL
- updated_at (Field3) — NULL
Post (게시물)
- post_id (PK) — NOTNULL — Primary key — NOT NULL
- user_id (PK2) — NOTNULL — Foreign key → User.user_id — NOT NULL
- content (Field) — NOTNULL
- visibility (Field2) — NOTNULL
- created_at (Field3) — NOTNULL
- updated_at (Field4) — NULL
User (회원)
- user_id (PK) — NOTNULL — Primary key — NOT NULL
- username (Field) — NOTNULL
- password (Field2) — NOTNULL
- user_role (Field3) — NOTNULL
- created_at (Field4) — NOTNULL
- updated_at (Field5) — NULL