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