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