DAMTIME
Tables (4)
login (damtime_user)
- No (Key) — INT — Primary key — NOT NULL
- userid (damtimeuser) — TEXT
- email (user_email) — TEXT — NOT NULL
- userpw (user_password) — TEXT
- salt (password_decode) — TEXT
- ban (user_ban) — BOOLEAN
public (public_marker)
- No (Key) — INT — Primary key — NOT NULL
- Gu (SmokingArea_Gu_type) — TEXT
- FacilityType (SmokingArea_FacilityType) — TEXT
- Location (SmokingArea_Location) — TEXT
- Description (SmokingArea_Description) — TEXT
- Latitude (SmokingArea_Latitude) — DOUBLE
- Longitude (SmokingArea_Longitude) — DOUBLE
report (marker_AdjustmentRequest)
- No (Key) — INT — Primary key — NOT NULL
- pinNo (marker_id) — INT
- type (Request_type) — TEXT
- owner (marker_creater) — TEXT
- reporter (marker_requester) — TEXT
- Location (Adjustment_Location) — TEXT
- FacilityType (Adjustment_FacilityType) — TEXT
- Description (Adjustment_Description) — TEXT
- Latitude (Adjustment_Latitude) — DOUBLE
- Longitude (Adjustment_Longitude) — DOUBLE
- note (addtional_requestment) — TEXT
userpin (user_marker)
- No (Key) — INT — Primary key — NOT NULL
- UserId (marker_creater) — TEXT
- FacilityType (SmokingArea_FacilityType) — TEXT
- Location (SmokingArea_Location) — TEXT
- Description (SmokingArea_Description) — TEXT
- Latitude (SmokingArea_Latitude) — DOUBLE
- Longitude (SmokingArea_Longitude) — DOUBLE