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, (파일경로)

Untitled (interest_area)