JejuYeora DB ERD

테이블 (13)

Untitled (notification)

  • Key (id) — String — 기본 키 — NOT NULL
  • Field (title) — String
  • Field (content) — String
  • Field (image) — String
  • Field2 (deeplink) — String
  • id (token_id) — String — 외래 키 → 알림 기기 토큰.id — NOT NULL
  • Field (is_read) — bool

Untitled (store_home)

  • Key (id) — String — 기본 키 — NOT NULL
  • Field (name) — String
  • Field2 (address) — String
  • Field3 (contact) — String
  • Field (coordinate) — String
  • 장례식장 종류(대학병원, 전문장례식장 등) (place_type) — String
  • Field (company_number) — String
  • Field (average_price) — float
  • Field (images) — String[]
  • Field (schedule) — String
  • Field (labels) — String
  • Field (notes) — String
  • Field (introduce_title) — String
  • Field (introduce_description) — String
  • Field (review_count) — number

Untitled (review)

  • Key (id) — String — 기본 키 — NOT NULL
  • id (user_id) — String — 외래 키 → 유저.id — NOT NULL
  • Key (store_id) — String — 외래 키 → Untitled.Key — NOT NULL
  • Field (created) — Date
  • Field (tags) — String[]

Untitled (pre_store_wish)

  • Key (id) — String — 기본 키 — NOT NULL
  • Field (details) — json
  • id (user_id) — String — 외래 키 → 유저.id — NOT NULL
  • Field (keword) — String
  • Field (created) — Date

Untitled (payment)

  • Key (id) — String — 기본 키 — NOT NULL
  • Field (amount) — float
  • Field (payment_status) — String
  • Field (created) — Date
  • id (user_id) — String — 외래 키 → 유저.id — NOT NULL
  • Key (store_id) — String — 외래 키 → Untitled.Key — NOT NULL
  • Key (pre_wish_id) — String — 외래 키 → Untitled.Key — NOT NULL
  • Field ({...pg_properties}) — etc
  • Field (original_price) — float
  • Field (scale) — String
  • Field (day) — String
  • Field (phone) — String

Untitled (store_guide)

  • Key (id) — String — 기본 키 — NOT NULL
  • Field (title) — String
  • Field (content) — longtext
  • Field (keyword) — String
  • Field (view_count) — int
  • Field (image) — String

Untitled (pre_wish_based_result)

  • Key (id) — String — 기본 키 — NOT NULL
  • Field (amount) — float
  • Key (pre_wish_id) — String — 외래 키 → Untitled.Key — NOT NULL
  • Key (funeral_id) — String — 외래 키 → Untitled.Key — NOT NULL

Untitled (store_product)

  • Key (id) — String — 기본 키 — NOT NULL
  • Key (funeral_id) — String — 외래 키 → Untitled.Key — NOT NULL
  • Field (amount) — float
  • Field (product_type) — String
  • Field (details) — json

Untitled (notice)

  • Key (id) — String — 기본 키 — NOT NULL
  • Field (title) — String
  • Field (content) — String
  • Field (created) — Date
  • Field (view_count) — int
  • Field (visible) — bool

Untitled (post)

  • Key (id) — String — 기본 키 — NOT NULL
  • Field (title) — String
  • Field (description) — String
  • Field (image) — String
  • Field (tags) — String[]
  • Field2 (created) — Date
  • Field (view_count) — String

소셜 계정 (socialaccount)

  • id — String — 기본 키 — NOT NULL
  • provider — varchar(200)
  • uid — varchar(191)
  • last_login — datetime(6)
  • date_joined — datetime(6)
  • extra_data — longtext
  • id (user_id) — String — 외래 키 → 유저.id — NOT NULL

알림 기기 토큰 (fcm_token)

  • id — String — 기본 키 — NOT NULL
  • 토큰 (token) — String
  • id (user_id) — String — 외래 키 → 유저.id — NOT NULL

유저 (auth_user)

  • id — String — 기본 키 — NOT NULL
  • password — varchar(128)
  • last_login — datetime(6)
  • is_superuser — tinyint(1)
  • username — varchar(150)
  • first_name — varchar(150)
  • last_name — varchar(150)
  • email — varchar(254)
  • is_staff — tinyint(1)
  • is_active — tinyint(1)
  • date_joined — datetime(6)
  • Field (gender) — String
  • Field (withdrawal_date) — Date