hellj
Tables (9)
Untitled (User)
- Key (id) — bigint — Primary key — NOT NULL — pk
- Field (email) — varchar — 이메일
- Field (password) — varchar — 비밀번호
- Field (nickname) — varchar — 닉네임
- Field (sub) — varchar — oauth2 sub
- Field (provider) — enum — 로그인방식 basic,google
- Field (role) — enum — test, user, admin
- Field (last_login) — timestampz — 마지막 로그인 시간
- Field (created_at) — timestampz — 생성시간
- Field (modified_at) — timestampz — 변경시간
Untitled (notice)
- Key (id) — bigint — Primary key — NOT NULL — pk
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — 유저아이디
- Field (TBD)
Untitled (legal_address)
- Field (code) — varchar(10) — Primary key — 법정동코드 idx btree
- Field (name) — varcahr — 지역명
- Field (type) — enum — 시도,시군구,읍면동
- Field (is_active) — boolean — 사용여부 default true
- Field (tbd)
Untitled (event_location)
- Key (id) — bigint — Primary key — NOT NULL — pk
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — not null
- Field (address_code) — varchar(10)( — Foreign key → Untitled.Field — 주소정보
- Field2 (loc) — Point — Geometry
- Field (address_detail) — varchar — 상세정보
- Field (created_at) — timestampz
- Field (updated_at) — timestampz
- Field (is_active) — boolean — default true
Untitled (event_post)
- Key (id) — bigint — Primary key — NOT NULL — pk
- Key (location_id) — bigint — Foreign key → Untitled.Key — NOT NULL — fk
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — fk
- Field (title) — varchar — 제목
- Field (content) — text — 내용
- Field (created_at) — timestamz — 생성시간
Untitled (comments)
- Key (id) — bigint — Primary key — NOT NULL — pk
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — fk
- Key (event_location_id) — bigint — Foreign key → Untitled.Key — NOT NULL — pk
- Field (created_at) — timestampz — 생성시간
- Field (modified_at) — timestampz — 수정시간
Untitled (event_recommend)
- Key (id) — bigint — Primary key — NOT NULL — pk
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — fk
- Key (event_id) — bigint — Foreign key → Untitled.Key — NOT NULL — fk
- Field (created_at) — timestampz — 생성시간
Untitled (File)
- Key (url) — varchar — Primary key — NOT NULL — pk, (파일경로)