제로

테이블 (6)

USERS (Untitled)

  • PK (product id) — 기본 키 — NOT NULL
  • name — varchar(50)
  • nickname — varchar(50)
  • latitude — double
  • longitude — double
  • location — varchar(50)
  • created_at — datetime
  • updated_at — datetime
  • role — enum('user', 'admin"
  • Field (image_url) — varchar(50)
  • Field (bottle_point) — Int
  • Field (latest_login_at) — datetime
  • Field (phone numeber) — varchar(20)

acheivement (Untitled5)

  • Key (pk) — 기본 키 — NOT NULL
  • Field (type)

comment (Untitled4)

  • pk (product id) — 기본 키 — NOT NULL
  • Field (pid) — fk
  • Field2 (user id) — fk
  • Field (description) — varchar(50)
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field (deleted_at) — datetime

community post (Untitled2)

  • pk (product id) — varchar — 기본 키 — NOT NULL
  • Field (title) — varchar(50)
  • Field (description) — string
  • Field (created_at) — datetime
  • Field (deleted_at) — datetime
  • Field

like (Untitled3)

  • Key (product id) — varchar — 기본 키 — NOT NULL
  • Field (count) — int
  • Field2 (pid) — fk
  • Field (user id) — fk
  • Field

polar_bear (Untitled6)

  • Key (id) — 기본 키 — NOT NULL
  • Field (user id)
  • Field (growth) — enum
  • Field (meat_count) — Int
  • Field (ice_size) — enum
  • Field