arttrip
Tables (21)
banned_word
- id — bigint — Primary key — NOT NULL
- active — boolean — NOT NULL
- created_at — timestamp(6) with time zone
- updated_at — timestamp(6) with time zone
- use_regex — boolean — NOT NULL
- word — varchar(100) — NOT NULL
curation
- id — bigint — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- active — boolean — NOT NULL
- display_count — bigint
- refresh_cycle — varchar(50) — NOT NULL
- sort_type — varchar(50)
- visible_from — date — NOT NULL
- visible_to — date — NOT NULL
- created_at — date — NOT NULL
- updated_at — date
curation_exhibit
- id — bigint — Primary key — NOT NULL
- curation_id — bigint — Foreign key → curation.id — NOT NULL
- display_order — int — NOT NULL
- exhibit_id — bigint — Foreign key → exhibit.exhibit_id — NOT NULL
exhibit
- exhibit_id — bigint — Primary key — NOT NULL
- exhibit_hall_id — bigint — Foreign key → exhibit_hall.id — NOT NULL
- title — varchar(255)
- description — text
- poster_url — varchar(1024)
- random_key — double precision — NOT NULL
- status — varchar(50) — NOT NULL
- ticket_url — varchar(1024)
- start_date — date
- end_date — date
- favorite_count — bigint
- updated_at — timestamp(6) with time zone
- created_at — timestamp(6) with time zone
exhibit_hall
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- address — varchar(255)
- phone — varchar(255)
- region — varchar(255)
- country — varchar(255)
- homepage_url — varchar(1024)
- is_domestic — boolean
- latitude — decimal(38, 2) — NOT NULL
- longitude — decimal(10, 7) — NOT NULL
- opening_hours — varchar(500)
- closed_days — varchar(255)
- created_at — timestamp(6) with time zone
- updated_at — timestamp(6) with time zone
exhibit_hall_seq
- next_val — bigint
exhibit_keyword
- exhibit_id — bigint — Foreign key → exhibit.exhibit_id — NOT NULL
- keyword_id — bigint — Foreign key → keyword.keyword_id — NOT NULL
exhibit_sync
- id — bigint — Primary key — NOT NULL
- exhibit_id — bigint — Foreign key → exhibit.exhibit_id — NOT NULL
- source — varchar(50) — NOT NULL
- external_id — varchar(255) — NOT NULL
- content_hash — char(64) — NOT NULL
- synced_at — timestamp(6) with time zone — NOT NULL
favorite
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- exhibit_id — bigint — Foreign key → exhibit.exhibit_id — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
keyword
- keyword_id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- type — varchar(50) — NOT NULL
maintenance
- id — bigint — Primary key — NOT NULL
- button_text — varchar(50) — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- end_at — timestamp(6) with time zone — NOT NULL
- force_exit — boolean — NOT NULL
- message — varchar(1000) — NOT NULL
- refresh_after_seconds — int — NOT NULL
- start_at — timestamp(6) with time zone — NOT NULL
- state — varchar(50) — NOT NULL
- title — varchar(100) — NOT NULL
- updated_at — timestamp(6) with time zone — NOT NULL
- version — bigint — NOT NULL
notice
- notice_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- title — varchar(255)
- content — varchar(255)
- role — varchar(50) — NOT NULL
- created_at — timestamp(6) with time zone
- updated_at — timestamp(6) with time zone
recent_exhibit
- id — bigint — Primary key — NOT NULL
- view_at — timestamp(6) with time zone
- exhibit_id — bigint — Foreign key → exhibit.exhibit_id
- user_id — bigint — Foreign key → users.id
region
- region_name — varchar(255) — Primary key — NOT NULL
- image_url — varchar(255) — NOT NULL
review
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- content — varchar(500) — NOT NULL
- status — varchar(50)
- visit_date — date
- exhibit_id — bigint — Foreign key → exhibit.exhibit_id — NOT NULL
- rejected_at — timestamp(6) with time zone
- rejection_reason — varchar(500)
- created_at — timestamp(6) with time zone — NOT NULL
- updated_at — timestamp(6) with time zone
review_image
- id — bigint — Primary key — NOT NULL
- review_id — bigint — Foreign key → review.id — NOT NULL
- curation_id — bigint — Foreign key → curation.id — NOT NULL
- display_order — int — NOT NULL
- image_url — varchar(255)
- created_at — timestamp(6) with time zone
search_history
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- content — varchar(255) — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
social_accounts
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- provider — varchar(50) — NOT NULL
- provider_user_id — varchar(255) — NOT NULL
- provider_refresh_token — text
- linked_at — timestamp(6) with time zone — NOT NULL
user_keyword
- id — bigint — Primary key — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- keyword_id — bigint — Foreign key → keyword.keyword_id
- user_id — bigint — Foreign key → users.id — NOT NULL
user_notice
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- title — varchar(255)
- action — varchar(50) — NOT NULL
- body — varchar(255)
- is_read — boolean — NOT NULL
- read_at — timestamp(6) with time zone
- reference_id — bigint
- created_at — timestamp(6) with time zone — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255)
- fcm_token — varchar(255)
- nick_name — varchar(255)
- onboarding_step — varchar(50) — NOT NULL
- profile_image_url — varchar(255)
- push_enabled — boolean — NOT NULL
- role — varchar(50) — NOT NULL
- stamp_num — smallint
- updated_at — timestamp(6) with time zone
- created_at — timestamp(6) with time zone — NOT NULL