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