제로
테이블 (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