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