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