Dangooon

Tables (7)

chat (Untitled7)

  • id (Key) — long — Primary key — NOT NULL
  • user (long) — Long — Foreign key → posts.id — NOT NULL
  • product (long2) — Long — Foreign key → users.id — NOT NULL

dealings (Untitled4)

  • id (long) — Primary key — NOT NULL
  • product (long3) — Long — Foreign key → posts.id — NOT NULL
  • buyer (long4) — Long — Foreign key → users.id — NOT NULL

interests (Untitled3)

  • id (long) — Primary key — NOT NULL
  • user (long2) — Long — Foreign key → users.id — NOT NULL
  • post (long3) — Long — Foreign key → posts.id — NOT NULL

posts (Untitled)

  • id (long) — Long — Primary key — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • views (Field3) — Int
  • price (Field4)
  • seller (long3) — Long — Foreign key → users.id — NOT NULL

product_photos (Untitled2)

  • id (long) — Primary key — NOT NULL
  • post (long2) — Long — Foreign key → posts.id — NOT NULL

reviews (Untitled5)

  • id (long) — Primary key — NOT NULL
  • reviewer — Long — Foreign key → users.id — NOT NULL
  • reviewee (long4) — Long — Foreign key → users.id — NOT NULL
  • post (long2) — Long — Foreign key → posts.id — NOT NULL

users

  • id (long) — Long — Primary key — NOT NULL
  • email (Field) — String
  • password (Field2) — String