test2

Tables (3)

Post (Untitled2)

  • post_id (Key) — BIGINT — Primary key — NOT NULL
  • writer_user_id (Key2) — BIGINT — Foreign key → Users.user_id — NOT NULL
  • title (Field) — VARCHAR(100)
  • content (Field2) — VARCHAR(5000)
  • created_at (Field3) — DATETIME
  • modified_at (Field4) — DATETIME

Users (Untitled)

  • user_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • age (Field2) — INT
  • email (Field5) — VARCHAR(100)
  • created_at (Field3) — DATETIME
  • modified_at (Field4) — DATETIME

UsersCredentialPW (Untitled3)

  • login_id (Key) — NVARCHAR(100) — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → Users.user_id — NOT NULL
  • login_pw (Field) — NVARCHAR(100)
  • salt (Field2) — NVARCHAR(100)
  • Field3