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