posting

Tables (5)

Alarm

  • id — bigint — Primary key — NOT NULL
  • userId — bigint — Foreign key → User.id — NOT NULL
  • alarmType — varchar
  • alarmText — varchar
  • createdAt — datetime
  • createdBy — varchar
  • modifiedAt — datetime
  • modifiedBy — varchar
  • deletedAt — datetime

Comment

  • id — bigint — Primary key — NOT NULL
  • userId — bigint — Foreign key → User.id — NOT NULL
  • postId (PostId) — bigint — Foreign key → Post.id — NOT NULL
  • comment — varchar
  • createdAt — datetime
  • createdBy — varchar
  • modifiedAt — datetime
  • modifiedBy — varchar
  • deletedAt — datetime

Like

  • id — bigint — Primary key — NOT NULL
  • userId — bigint — Foreign key → User.id — NOT NULL
  • postId (PostId) — bigint — Foreign key → Post.id — NOT NULL
  • createdAt — datetime
  • createdBy — varchar
  • modifiedAt — datetime
  • modifiedBy — varchar
  • deletedAt — datetime

Post

  • id — bigint — Primary key — NOT NULL
  • userId — bigint — Foreign key → User.id — NOT NULL
  • title — varchar
  • content — varchar
  • createdAt — datetime
  • createdBy — varchar
  • modifiedAt — datetime
  • modifiedBy — varchar
  • deletedAt — datetime

User

  • id — bigint — Primary key — NOT NULL
  • username — varchar
  • email — varchar
  • password — varchar
  • role — varchar
  • createdAt — datetime
  • createdBy — varchar
  • modifiedAt — datetime
  • modifiedBy — varchar
  • deletedAt — datetime