Musinsa-be

Tables (3)

Untitled (tb_user)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (email) — VARCHAR(100)
  • Field2 (password) — VARCHAR(255)
  • Field3 (type) — VARCHAR(20)
  • Field (is_deleted) — BOOLEAN
  • Field (created_at) — DATETIME
  • Field (modified_at) — DATETIME

Untitled (tb_address)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (user_id) — INT
  • Field2 (address) — VARCHAR(255)
  • Field (detail) — VARCHAR(255)
  • Field2 (postcode) — VARCHAR(20)
  • Field (is_defaulted) — BOOLEAN
  • Field (created_at) — DATETIME
  • Field (modified_at) — DATETIME

Untitled (tb_profile)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(25)
  • Field2 (gender) — CHAR(1)
  • Field3 (nickname) — VARCHAR(25)
  • Field (tall) — FLOAT
  • Field (weight) — FLOAT
  • Field (craeted_at) — DATETIME
  • Field2 (modified_at) — DATETIME
  • Field (profile_url) — VARCHAR(255)