bulletin board

Tables (4)

comment (Untitled2)

  • comment_id (Key2) — Primary key — NOT NULL
  • board_id (Key) — Foreign key → post.post_id — NOT NULL
  • member_id (Key3) — Foreign key → member.member_id — NOT NULL
  • content (Field2)
  • created_datetime (Field3)
  • last_modified_datetime (Field4)
  • is_shown (Field)

member (Untitled3)

  • member_id (Key) — Primary key — NOT NULL
  • id (Field)
  • password (Field2)
  • refresh_token (Field3)
  • expires_at (Field4)

post (Untitled)

  • post_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL
  • title (Field)
  • content (Field2)
  • created_datetime (Field3)
  • last_modified_datetime (Field4)
  • is_shown (Field5)
  • like (Field6)

post_like (Untitled4)

  • post_like_id (Key3) — Primary key — NOT NULL
  • post_id (Key) — Foreign key → post.post_id — NOT NULL
  • member_id (Key2) — Foreign key → post.member_id — NOT NULL