dopamine

Tables (10)

auction_item

  • id (Key) — Primary key — NOT NULL
  • description (Field2)
  • category (Field3)
  • duration (Field4)
  • delivery (Field5)
  • who_pay_deliveryfee (Field6)
  • id (Key2) — Foreign key → user.id — NOT NULL

bid

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → auction_item.id — NOT NULL
  • id (Key3) — Foreign key → user.id — NOT NULL

chat_message

  • id (Key) — Foreign key → user.id — NOT NULL
  • Key (Key2) — Foreign key → chat_room.Key — NOT NULL

chat_room

  • Key — Primary key — NOT NULL

image

  • id (Key) — Primary key — NOT NULL
  • auction_item_id (Key2) — Foreign key → auction_item.id — NOT NULL

pending

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → auction_item.id — NOT NULL
  • id (Key3) — Foreign key → user.id — NOT NULL

point_history

  • id (Key2) — Primary key — NOT NULL
  • user_id (Key) — Foreign key → user.id — NOT NULL

q&a

  • id (Key2) — Primary key — NOT NULL
  • auction_item_id (Key) — Foreign key → auction_item.id — NOT NULL
  • content (Field)

user

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • email (Field)
  • nickname (Field2)
  • point (Field3)

user_chat_room

  • id (Key) — Foreign key → user.id — NOT NULL
  • Key (Key2) — Foreign key → chat_room.Key — NOT NULL