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