JangTrello
Tables (3)
Card
- id — bigint — Primary key — NOT NULL
- created_at — timestamp
- created_by — varchar
- modified_at — timestamp
- modified_by — varchar
- email — varchar
- nickname — varchar
- title — varchar
- status — varchar
- contents — varchar
- comments — comment
- user_id — bigint — Foreign key → Users.id — NOT NULL
Comment
- id — bigint — Primary key — NOT NULL
- created_at — timestamp
- created_by — varchar
- modified_at — timestamp
- modified_by — varchar
- email — varchar
- nickname — varchar
- contents — varchar
- user_id — bigint — Foreign key → Users.id — NOT NULL
- card_id — bigint — Foreign key → Card.id — NOT NULL
Users
- id — bigint — Primary key — NOT NULL
- created_at — timestamp
- created_by — varchar
- modified_at — timestamp
- modified_by — varchar
- password — varchar
- email — varchar
- nickname — varchar
- role — varchar