auction

Tables (6)

bid

  • Key (id(pk)) — Primary key — NOT NULL
  • Field (start_price)
  • Field2 (re_price)
  • Field3 (final_price)
  • Field4 (start_date)
  • Field5 (re_date)
  • Field6 (final_date)
  • Field7 (status)
  • Field8 (feed_date)
  • Key (seller_id) — Foreign key → user.Key — NOT NULL
  • Key (buyer_id) — Foreign key → feed.Key — NOT NULL

category

  • Key (id(pk)) — Primary key — NOT NULL
  • Field (number)
  • Field2 (name)

comment

  • Key (id(pk)) — Primary key — NOT NULL
  • Field (user_id)
  • Field2 (content)
  • Field3 (date)
  • Key (feed_id) — Foreign key → feed.Key — NOT NULL

feed

  • Key (id(pk)) — Primary key — NOT NULL
  • Field1 (title) — Type
  • Field2 (content)
  • Field3 (file)
  • Field4 (date)
  • Field7 (comment_id)
  • Field8 (comment_content)
  • Field9 (comment_date)
  • Field10 (like_count)
  • Field11 (start_price)
  • Field12 (re_price)
  • Field13 (final_price)
  • Field14 (start_date)
  • Field15 (re_date)
  • Field16 (final_date)
  • Field17 (status)
  • Key (user_id) — Foreign key → user.Key — NOT NULL
  • Key (category) — Foreign key → category.Key — NOT NULL
  • Key (bid) — Foreign key → bid.Key — NOT NULL

like

  • Key (id(pk)) — Primary key — NOT NULL
  • Field1 (count)
  • Field2 (content)
  • Field (user_id)
  • Key (feed_id) — Foreign key → feed.Key — NOT NULL

user

  • Key (id(pk)) — Primary key — NOT NULL
  • Field (user_id)
  • Field2 (name)
  • Field3 (pw)