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
  • ... — ...