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