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