ourmarket

Tables (5)

Item (Untitled)

  • _id (Key) — Primary key — NOT NULL
  • user_id (Field3)
  • title (Field9)
  • cover_image (Field)
  • like_count (Field4)
  • scrap_count (Field5)
  • price (Field6)
  • created_date (Field7)
  • updated_date (Field8)
  • content (Field10)

Likes (Untitled4)

  • _id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Primary key — NOT NULL
  • item_id (Key3) — Primary key — NOT NULL

Scraps (Untitled5)

  • _id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Primary key — NOT NULL
  • item_id (Key3) — Primary key — NOT NULL

Transaction (Untitled3)

  • _id (Key) — Primary key — NOT NULL
  • seller_id (Field)
  • buyer_id (Field2)
  • item_id (Field3)
  • created_date (Field4)
  • finish_date (Field5)

User (Untitled2)

  • _id (Key) — Primary key — NOT NULL
  • account (Key2) — Primary key — NOT NULL
  • profile_image (Field)
  • background_image (Field2)