space_group
Tables (6)
room_occupancy
- id — BIGINT — Primary key — NOT NULL
- space_id — BIGINT — Foreign key → space.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- team_id — BIGINT — Foreign key → team.id
- started_at — TIMESTAMPTZ — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- extension_count — SMALLINT — NOT NULL
- reminder_sent_at — TIMESTAMPTZ
- status — VARCHAR(15) — NOT NULL
- ended_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
space
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- type — VARCHAR(10) — NOT NULL
- capacity — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
team
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
team_member
- id — BIGINT — Primary key — NOT NULL
- team_id — BIGINT — Foreign key → team.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- role — VARCHAR(10) — NOT NULL
- joined_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- deleted_at — TIMESTAMPTZ
vacancy_alert
- id — BIGINT — Primary key — NOT NULL
- space_id — BIGINT — Foreign key → space.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- notified_at — TIMESTAMPTZ