Manda
Tables (4)
Mandarat
- mandarat_id (Key) — BIGINT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- Key (user_id) — BIGINT — Foreign key → User.Key — NOT NULL
Mandarat_Item
- item_id — BIGINT — Primary key — NOT NULL
- mandarat_id (Key) — BIGINT — Foreign key → Mandarat.mandarat_id — NOT NULL
- content — VARCHAR(255) — NOT NULL
- position — INT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Refresh_Token
- token_id — BIGINT — Primary key — NOT NULL
- refresh_token — VARCHAR(255) — NOT NULL
- expiry_date — TIMESTAMP — NOT NULL
- Key (user_id) — BIGINT — Foreign key → User.Key — NOT NULL
User
- Key (user_id) — BIGINT — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- roles — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP