backend

Tables (10)

Untitled (shop_board)

  • Key (board_id) — NOT NULL — Primary key — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → user.id
  • Field (title) — NOT NULL
  • Field (content) — NOT NULL
  • Field (img_url) — NOT NULL
  • Field (price) — NOT NULL
  • Field (status) — NOT NULL
  • Field (create_date) — NOT NULL
  • Field (update_date) — NOT NULL
  • Field (sold_date) — NOT NULL
  • Field (like) — NOT NULL
  • Field (seller_id) — NULL

Untitled (Board)

  • Key (board_id) — NOT NULL — Primary key — NOT NULL
  • Field (writer) — NOT NULL
  • Field (password) — NOT NULL
  • Field (title) — NOT NULL
  • Field (content) — NOT NULL
  • Field (create_date) — NOT NULL
  • Field2 (update_date) — NOT NULL
  • Field (status) — NOT NULL
  • Field (like) — NOT NULL
  • Field2 (distlike) — NOT NULL

Untitled (board_comment)

  • Key (comment_id) — NOT NULL — Primary key — NOT NULL
  • Key (board_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field (writer) — NOT NULL
  • Field (password) — NOT NULL
  • Field (content) — NOT NULL
  • Field (create_date) — NOT NULL
  • Field (update_date) — NOT NULL

Untitled (point_board)

  • Key (point_board_id) — NOT NULL — Primary key — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → user.id
  • Field (charge_point) — NOT NULL
  • Field (date) — NOT NULL
  • Field (status) — NOT NULL

Untitled (Address)

  • Field (zipcode) — NOT NULL
  • Field2 (address) — NOT NULL
  • Field3 (address detail) — NOT NULL

Untitled (comment)

  • Key (comment_id) — NOT NULL — Primary key — NOT NULL
  • Key (board_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → Untitled.id
  • Field (comment) — NOT NULL
  • Field (create_date) — NOT NULL
  • Field (update_date) — NOT NULL

Untitled2 (profile)

  • Key (profile_id) — NOT NULL — Primary key — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → user.id
  • Field (nick_name) — NOT NULL
  • Field (create_date) — NOT NULL
  • Field (update_date) — NOT NULL

Untitled2 (authentication)

  • Key (authentication_id) — NOT NULL — Primary key — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → user.id
  • Field (age) — NOT NULL
  • Field (gender) — NOT NULL
  • Field (address) — NOT NULL

Untitled2 (password)

  • Key (password_id) — NOT NULL — Primary key — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → user.id
  • Field (password) — NOT NULL
  • Field (update_date) — NOT NULL

user

  • id (user_id) — NOT NULL — Primary key
  • Field (id) — NOT NULL
  • Field2 (login_type) — NOT NULL
  • Field (point) — NOT NULL