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