zzan

Tables (20)

accommodations

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(30)
  • address — TEXT — NOT NULL
  • phone — VARCHAR(20)
  • website — TEXT
  • description — TEXT
  • image_url — TEXT
  • lat — DOUBLE PRECISION — NOT NULL
  • lng — DOUBLE PRECISION — NOT NULL
  • geom — GEOMETRY(POINT, 4326)
  • region — VARCHAR(50)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

breweries

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • address — TEXT — NOT NULL
  • phone — VARCHAR(20)
  • website — TEXT
  • description — TEXT
  • image_url — TEXT
  • lat — DOUBLE PRECISION
  • lng — DOUBLE PRECISION
  • geom — GEOMETRY(POINT, 4326)
  • avg_rating — NUMERIC(3,2) — NOT NULL
  • review_count — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

brewery_stamps

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • brewery_id — UUID — NOT NULL
  • lat — DOUBLE PRECISION — NOT NULL
  • lng — DOUBLE PRECISION — NOT NULL
  • stamped_at — TIMESTAMPTZ — NOT NULL

comment_likes

  • id — UUID — Primary key — NOT NULL
  • comment_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

comments

  • id — UUID — Primary key — NOT NULL
  • post_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • body — TEXT — NOT NULL
  • like_count — INTEGER — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

course_stops

  • id — UUID — Primary key — NOT NULL
  • course_id — UUID — NOT NULL
  • stop_order — SMALLINT — NOT NULL
  • stop_type — stop_type — NOT NULL
  • ref_id — UUID — NOT NULL
  • note — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

courses

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • region — VARCHAR(50)
  • source — course_source — NOT NULL
  • bti_type — VARCHAR(20)
  • is_public — BOOLEAN — NOT NULL
  • dynamo_id — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL

festivals

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • location — TEXT
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • description — TEXT
  • image_url — TEXT
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

foods

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • address — TEXT
  • description — TEXT
  • image_url — TEXT
  • pairings — TEXT
  • lat — DOUBLE PRECISION
  • lng — DOUBLE PRECISION
  • geom — GEOMETRY(POINT, 4326)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

liquors

  • id — UUID — Primary key — NOT NULL
  • brewery_id — UUID — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • alcohol_content — NUMERIC(4,1)
  • price — INTEGER
  • description — TEXT
  • image_url — TEXT
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

markets

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • address — TEXT — NOT NULL
  • open_days — SMALLINT
  • description — TEXT
  • image_url — TEXT
  • lat — DOUBLE PRECISION — NOT NULL
  • lng — DOUBLE PRECISION — NOT NULL
  • geom — GEOMETRY(POINT, 4326)
  • region — VARCHAR(50)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

notifications

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • type — notification_type — NOT NULL
  • message — TEXT — NOT NULL
  • ref_type — VARCHAR(30)
  • ref_id — UUID
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

post_likes

  • id — UUID — Primary key — NOT NULL
  • post_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

posts

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • body — TEXT — NOT NULL
  • category — post_category — NOT NULL
  • images — TEXT
  • like_count — INTEGER — NOT NULL
  • comment_count — INTEGER — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

refresh_tokens

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • family_id — UUID — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • revoked_at — TIMESTAMPTZ
  • ip_address — INET
  • user_agent — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

reports

  • id — UUID — Primary key — NOT NULL
  • reporter_id — UUID — NOT NULL
  • target_type — report_target_type — NOT NULL
  • target_id — UUID — NOT NULL
  • reason — TEXT — NOT NULL
  • status — report_status — NOT NULL
  • note — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

review_likes

  • id — UUID — Primary key — NOT NULL
  • review_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

reviews

  • id — UUID — Primary key — NOT NULL
  • brewery_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • rating — SMALLINT — NOT NULL
  • body — TEXT
  • like_count — INTEGER — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

social_accounts

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255)
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image — TEXT
  • bti_type — VARCHAR(20)
  • is_admin — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ