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