Trailblazer_DB

Tables (11)

admins (CopyOfUntitled)

  • admin_uuid (Key) — varchar — Primary key — NOT NULL
  • admin_id (Field) — varchar — NOT NULL
  • admin_password (Field2) — text — NOT NULL
  • admin_name (Field3) — varchar — NOT NULL

buildings

  • building_id (uuid) — varchar — Primary key — NOT NULL
  • official_code (Field) — varchar — NOT NULL
  • name (Field2) — varchar — NOT NULL
  • alias (Field3) — varchar — NOT NULL
  • description (Field4) — text — NOT NULL
  • max_floor (Field5) — int4 — NOT NULL
  • longitude (Field6) — float8 — NOT NULL
  • latitude (Field7) — float8 — NOT NULL

contributions (CopyOfUntitled3)

  • contribution_id (Key) — varchar — Primary key — NOT NULL
  • contribution_type (Field) — varchar — NOT NULL
  • contribution_status (Field6) — varchar — NOT NULL
  • created_at (Field2) — timestamptz — NOT NULL
  • approved_at (Field3) — timestamptz
  • official_code (Field4) — varchar
  • name (Field5) — varchar
  • alias (Field7) — varchar
  • max_floor (Field8) — int4
  • longitude (Field9) — float8
  • latitude (Field10) — float8
  • floor (Field11) — int4
  • description (Field12) — text
  • room_number (Field13) — varchar
  • fk__contributions__users (Key2) — varchar — Foreign key → users.user_uuid — NOT NULL
  • fk__contributions__buildings (uuid) — varchar — Foreign key → buildings.building_id
  • fk__contributions__location_categories (uuid2) — varchar — Foreign key → location_categories.category_id

email_schedules (CopyOfCopyOfUntitled4)

  • schedule_id (Key) — varchar — Primary key — NOT NULL
  • content (Field) — text — NOT NULL
  • send_trial_count (Field6) — int4 — NOT NULL
  • is_success (Field2) — boolean — NOT NULL
  • fk__email_schedules__prove_trials (Key2) — varchar — Foreign key → prove_trials.trial_id — NOT NULL

images (CopyOfbuildings2)

  • id (uuid) — varchar — Primary key — NOT NULL
  • img_url (Field) — varchar — NOT NULL
  • fk__images__buildings (uuid2) — varchar — Foreign key → locations.location_id
  • fk__images__locations (uuid3) — varchar — Foreign key → buildings.building_id

location_categories (CopyOfCopyOfbuildings)

  • category_id (uuid) — varchar — Primary key — NOT NULL
  • name (Field) — varchar — NOT NULL
  • description (Field2) — text — NOT NULL

locations (CopyOfbuildings)

  • location_id (uuid) — varchar — Primary key — NOT NULL
  • name (Field) — varchar — NOT NULL
  • floor (Field2) — int4 — NOT NULL
  • description (Field3) — text — NOT NULL
  • room_number (Field4) — varchar
  • fk__locaitons__buildings (uuid2) — varchar — Foreign key → buildings.building_id — NOT NULL
  • fk__locations__location_categories (uuid3) — varchar — Foreign key → location_categories.category_id — NOT NULL

prove_trials (CopyOfUntitled4)

  • trial_id (Key) — varchar — Primary key — NOT NULL
  • created_at (Field) — timestamptz — NOT NULL
  • verify_code (Field6) — varchar — NOT NULL
  • proved_at (Field5) — timestamptz
  • fk__prove_trials__users (Key2) — varchar — Foreign key → users.user_uuid — NOT NULL

search_histories (CopyOfUntitled2)

  • history_id (Key) — varchar — Primary key — NOT NULL
  • created_at (Field6) — timestamptz — NOT NULL
  • fk__search_histories__buildings (uuid) — varchar — Foreign key → buildings.building_id
  • fk__search_histories__locations (uuid2) — varchar — Foreign key → locations.location_id
  • fk__search_histories__users (Key2) — varchar — Foreign key → users.user_uuid — NOT NULL

user_saves (Untitled2)

  • mapping_id (Key) — varchar — Primary key — NOT NULL
  • fk__user_saves__users (Key2) — varchar — Foreign key → users.user_uuid — NOT NULL
  • fk__uesr_saves__buildings (uuid) — varchar — Foreign key → buildings.building_id — NOT NULL
  • fk__user_saves__locations (uuid2) — varchar — Foreign key → locations.location_id — NOT NULL

users (Untitled)

  • user_uuid (Key) — varchar — Primary key — NOT NULL
  • user_id (Field) — varchar — NOT NULL
  • user_password (Field6) — text — NOT NULL
  • user_name (Field2) — varchar — NOT NULL
  • is_proven_user (Field3) — boolean — NOT NULL
  • user_email (Field4) — varchar
  • user_status (Field5) — varchar — NOT NULL