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