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)