Dolpin ERD By 떡잎마을 방범대 (v1.0.0)
테이블 (12)
comment
- id — BIGSERIAL — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- moment_id — BIGINT — 외래 키 → moment.id — NOT NULL
- content — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
keyword
- id — BIGSERIAL — 기본 키 — NOT NULL
- keyword — VARCHAR(255) — NOT NULL
moment
- id — BIGSERIAL — 기본 키 — NOT NULL
- place_id — BIGINT — 외래 키 → place.id — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- content — TEXT — NOT NULL
- title — VARCHAR(50) — NOT NULL
- is_public — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
moment_image
- id — BIGSERIAL — 기본 키 — NOT NULL
- moment_id — BIGINT — 외래 키 → moment.id — NOT NULL
- image_url — VARCHAR(255)
- image_sequence — INTEGER — NOT NULL
place
- id — BIGINT — 기본 키 — NOT NULL — 크롤링 데이터 ID 값 사용
- place_category_id — BIGINT — 외래 키 → place_category.id — NOT NULL
- location — GEOMETRY(Point, 4326) — NOT NULL
- description — VARCHAR(100) — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20)
- lot_address — VARCHAR(255) — NOT NULL
- road_address — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
place_bookmark
- id — BIGSERIAL — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- place_id — BIGINT — 외래 키 → place.id — NOT NULL — 크롤링 데이터 ID 값 사용
- created_at — TIMESTAMPTZ — NOT NULL
place_category
- id — BIGSERIAL — 기본 키 — NOT NULL
- name — VARCHAR(10) — NOT NULL
place_hours
- id — BIGSERIAL — 기본 키 — NOT NULL
- place_id — BIGINT — 외래 키 → place.id — NOT NULL
- day_of_week — ENUM — NOT NULL
- open_time — VARCHAR(10) — NOT NULL
- close_time — VARCHAR(10) — NOT NULL
- is_break_time — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
place_keyword
- id — BIGSERIAL — 기본 키 — NOT NULL
- place_id — BIGINT — 외래 키 → place.id — NOT NULL
- keyword_id — BIGINT — 외래 키 → keyword.id — NOT NULL
place_menu
- id — BIGSERIAL — 기본 키 — NOT NULL
- place_id — BIGINT — 외래 키 → place.id — NOT NULL
- price — INTEGER
- menu_name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
refresh_token
- id — BIGSERIAL — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- token — TEXT — NOT NULL
- is_revoked — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- expired_at — TIMESTAMPTZ — NOT NULL
user
- id — BIGSERIAL — 기본 키 — NOT NULL
- provider_id — BIGINT — NOT NULL
- provider — VARCHAR(10) — NOT NULL
- image_url — VARCHAR(255)
- introduction — VARCHAR(70)
- username — VARCHAR(10) — NOT NULL
- is_location_agreed — BOOLEAN — NOT NULL
- is_privacy_agreed (privacy_agreed) — BOOLEAN — NOT NULL
- privacy_agreed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL