CoworkingSpace

Tables (5)

site_area (Untitled4)

  • site_id (Key) — INTEGER — Primary key — NOT NULL
  • area (Field) — INTEGER

trial_access_log (Untitled2)

  • site_id (Key2) — INTEGER — Foreign key → site_area.site_id — NOT NULL
  • user_id (Key) — INTEGER — Foreign key → trial_register.user_id — NOT NULL
  • timestamp — TIMESTAMP
  • chekin (Field) — INTEGER

trial_payment (Untitled3)

  • user_id (Key) — INTEGER — Foreign key → trial_register.user_id — NOT NULL
  • is_payment (Field) — BOOLEAN

trial_register (Untitled)

  • user_id (Key) — INTEGER — Primary key — NOT NULL
  • timestamp — TIMESTAMP

trial_visit_info (trial)

  • site_id (Key2) — INTEGER — Foreign key → site_area.site_id — NOT NULL
  • user_id (Key) — INTEGER — Foreign key → trial_register.user_id — NOT NULL
  • date (data) — DATE
  • stay_time (Field) — TIME
  • stay_time_second (Field2) — INTEGER
  • first_enter_time (Field3) — TIMESTAMP
  • last_leave_time (Field4) — TIMESTAMP