SOPT_everytime

Tables (3)

post (Untitled2)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR
  • content (Field2) — VARCHAR
  • board_type (Field3) — VARCHAR
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME
  • user_id (FK) — BIGINT — Foreign key → users.id — NOT NULL

post_like (Untitled3)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • user_id (Field) — BIGINT
  • post_id (Field2) — BIGINT
  • created_at (Field3) — DATETIME
  • updated_at (Field4) — DATETIME
  • user_id (FK) — BIGINT — Foreign key → users.id — NOT NULL
  • post_id (FK2) — BIGINT — Foreign key → post.id — NOT NULL

users (Untitled)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • nickname (Field2) — VARCHAR
  • email (Field3) — VARCHAR