calBook

Tables (6)

appointment_member

  • appointment_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Primary key — NOT NULL
  • paid — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

appointments

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • host_id — INTEGER — NOT NULL
  • total_cost — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

friends

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • friend_id — INTEGER — NOT NULL
  • status — friend_status
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • CHECK — (user_id <> friend_id)

settlements

  • id — SERIAL
  • appointment_id — INTEGER — NOT NULL
  • user_id — INTEGER — NOT NULL
  • amount — INTEGER
  • paid — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

transactions

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • type — transaction_type — NOT NULL
  • amount — INTEGER
  • category — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

users

  • id — SERIAL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP