community

Tables (3)

Untitled (Post)

  • id — BIGINT — Primary key — NOT NULL
  • title — varchar
  • content — varchar
  • comment_count — BIGINT
  • created_date — DATETIME
  • modified_date — DATETIME
  • removed_date — DATETIME
  • user_id — BIGINT — Foreign key → User.id — NOT NULL

Untitled (Comment)

  • id — BIGINT — Primary key — NOT NULL
  • content — varchar
  • created_date — DATETIME
  • modified_date — DATETIME
  • removed_date — DATETIME
  • post_id — BIGINT — Foreign key → Untitled.id — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL

User

  • id — BIGINT — Primary key — NOT NULL
  • user_table_id — varchar
  • password — varchar
  • created_date — DATETIME
  • role — varchar