croud_sourcing

Tables (9)

category (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String

city (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String

district (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • city_id (Key2) — Long — Foreign key → city.id — NOT NULL
  • name (Field) — String

mart (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • district_id (Key2) — Long — Foreign key → district.id — NOT NULL
  • city_id (Key22) — Long — Foreign key → district.city_id — NOT NULL
  • lat (Field2) — Double
  • lng (Field3) — Double
  • name (Field4) — String

point (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.id — NOT NULL
  • date (Field) — LocalDateTime
  • amount (Field2) — Int

request (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • requester_id (Key4) — Long — Foreign key → user.id — NOT NULL
  • category_id (Key2) — Long — Foreign key → category.id — NOT NULL
  • mart_id (Key3) — Long — Foreign key → mart.id — NOT NULL
  • district_id (Key22) — Long — Foreign key → mart.district_id — NOT NULL
  • city_id (Key222) — Long — Foreign key → mart.city_id — NOT NULL
  • name (Field) — String
  • personPerPoint (Field2) — Int
  • maxParticipants (Field3) — Int
  • currentParticipants (Field4) — Int
  • closing_period (Field5) — LocalDateTime

serachLog (Untitled9)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.id — NOT NULL
  • serchKey (Field) — String
  • serachAt (Field2) — LocalDateTime

user (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • point (Field2) — Int
  • lat (Field3) — Double
  • lng (Field4) — Double

work (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • worker_id (Key4) — Long — Foreign key → user.id — NOT NULL
  • request_id (Key42) — Long — Foreign key → request.requester_id — NOT NULL
  • requester_id (Key2) — Long — Foreign key → request.id — NOT NULL
  • category_id (Key22) — Long — Foreign key → request.category_id — NOT NULL
  • mart_id (Key3) — Long — Foreign key → request.mart_id — NOT NULL
  • district_id (Key222) — Long — Foreign key → request.district_id — NOT NULL
  • city_id (Key2222) — Long — Foreign key → request.city_id — NOT NULL
  • status (Field) — String
  • point (Field2) — Int
  • price (Field3) — Int
  • name (Field4) — Int