yeongn

Tables (6)

Appraisal (appraisal)

  • ID (id) — int — Primary key — NOT NULL
  • UserID (user_id) — int — Foreign key → Users.ID — NOT NULL
  • Category (category) — varchar(255)
  • ItemName (item_name) — varchar(255)
  • Description (descriptsion) — varchar(255)
  • ImgUrl (img_url) — varchar(255)
  • CreatedAt (created_at) — datetime
  • Price (price) — int

Appraisals Comments (appraisals_comments)

  • ID (id) — int — Primary key — NOT NULL
  • AppraisalID (appraisal_id) — int — Foreign key → Appraisal.ID — NOT NULL
  • userID (user_id) — int — Foreign key → Users.ID — NOT NULL
  • Comment (comment) — varchar(255)
  • CreatedAt (created_at) — datetime

Sales (sales)

  • ID (id) — int — Primary key — NOT NULL
  • UserId (user_id) — int — Foreign key → Users.ID — NOT NULL
  • Category (category) — int
  • ItemName (item_name) — varchar(255)
  • UserPrice (user_price) — int
  • Description (description) — varchar(255)
  • imgUrl (img_url) — varchar(255)
  • CreatedAt (created_at) — datetime

Sales Comments (sales_comments)

  • ID (id) — int — Primary key — NOT NULL
  • UserId (user_id) — int — Foreign key → Users.ID — NOT NULL
  • SaleId (sale_id) — int — Foreign key → Sales.ID — NOT NULL
  • Comment (comment) — varchar(255)
  • CreatedAt (created_at) — datetime

Users (users)

  • ID (id) — int — Primary key — NOT NULL
  • Nickname (nickname) — varchar(255)
  • Email (email) — varchar(255)
  • Social (social) — varchar(255)
  • CreatedAt (created_at) — datetime

Users Appraisals Prices (users_appraisals_prices)

  • ID (id) — int — Primary key — NOT NULL
  • AppraisalID (appraisal_id) — int — Foreign key → Appraisal.ID — NOT NULL
  • userID (user_id) — int — Foreign key → Users.ID — NOT NULL
  • Price (price) — int