MyGate

Tables (3)

Untitled (community)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (title) — string
  • Field2 (content) — string
  • Field3 (created_at) — datetime
  • Field4 (updated_at) — datetime
  • Field (status) — boolean
  • Field (category) — string
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL

Untitled (comment)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (content) — string
  • Field2 (created_at) — datetime
  • Field3 (updated_at) — datetime
  • Field (status) — boolean
  • Key (user_id) — bigint — Foreign key → user.Key — NOT NULL — 댓글 쓴 유저의 id
  • Key (community_id) — bigint — Foreign key → Untitled.Key — NOT NULL

user

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — string
  • Field2 (phone_num) — string
  • Field3 (pw) — string
  • Field4 (birth) — datetime
  • Field (gender) — string
  • Field2 (img_url) — string
  • Field3 (location) — string
  • Field (created_at) — datetime
  • Field (updated_at) — datetime
  • Field4 (status) — boolean