middle_project2

Tables (5)

site_area_df (Untitled)

  • site_id — Primary key — NOT NULL
  • area_pyeong

trial_access_log

  • id — Primary key — NOT NULL
  • checkin
  • cdate
  • site_id — Foreign key → site_area_df.site_id — NOT NULL
  • user_uuid — Foreign key → trial_register_df.user_uuid — NOT NULL

trial_payment

  • is_payment
  • user_uuid (user_uuid2) — Foreign key → trial_register_df.user_uuid — NOT NULL

trial_register_df

  • user_uuid — Primary key — NOT NULL
  • trial_date

trial_visit_info

  • site_id — Foreign key → site_area_df.site_id — NOT NULL
  • date
  • stay_time
  • stay_time_second
  • first_enter_time
  • last_leave_time
  • Field
  • user_uuid — Foreign key → trial_register_df.user_uuid — NOT NULL