-
Notifications
You must be signed in to change notification settings - Fork 7
/
yobo.schema
1 lines (1 loc) · 9.11 KB
/
yobo.schema
1
{"Columns@":[{"Key":"dbo.Lessons","Value":{"serializedData":[{"key":"Created","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"Created","TypeInfo@":{"value":"datetimeoffset"},"TypeMapping@":{"ClrType@":"System.DateTimeOffset","DbType@":27,"ProviderTypeName@":{"value":"datetimeoffset"},"ProviderType@":{"value":34}}}},{"key":"Description","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"Description","TypeInfo@":{"value":"nvarchar(-1)"},"TypeMapping@":{"ClrType@":"System.String","DbType@":16,"ProviderTypeName@":{"value":"nvarchar"},"ProviderType@":{"value":12}}}},{"key":"EndDate","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"EndDate","TypeInfo@":{"value":"datetimeoffset"},"TypeMapping@":{"ClrType@":"System.DateTimeOffset","DbType@":27,"ProviderTypeName@":{"value":"datetimeoffset"},"ProviderType@":{"value":34}}}},{"key":"Id","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":true,"Name@":"Id","TypeInfo@":{"value":"uniqueidentifier"},"TypeMapping@":{"ClrType@":"System.Guid","DbType@":9,"ProviderTypeName@":{"value":"uniqueidentifier"},"ProviderType@":{"value":14}}}},{"key":"IsCancelled","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"IsCancelled","TypeInfo@":{"value":"bit"},"TypeMapping@":{"ClrType@":"System.Boolean","DbType@":3,"ProviderTypeName@":{"value":"bit"},"ProviderType@":{"value":2}}}},{"key":"Name","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"Name","TypeInfo@":{"value":"nvarchar(-1)"},"TypeMapping@":{"ClrType@":"System.String","DbType@":16,"ProviderTypeName@":{"value":"nvarchar"},"ProviderType@":{"value":12}}}},{"key":"StartDate","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"StartDate","TypeInfo@":{"value":"datetimeoffset"},"TypeMapping@":{"ClrType@":"System.DateTimeOffset","DbType@":27,"ProviderTypeName@":{"value":"datetimeoffset"},"ProviderType@":{"value":34}}}}]}},{"Key":"dbo.LessonReservations","Value":{"serializedData":[{"key":"Count","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"Count","TypeInfo@":{"value":"int"},"TypeMapping@":{"ClrType@":"System.Int32","DbType@":11,"ProviderTypeName@":{"value":"int"},"ProviderType@":{"value":8}}}},{"key":"Created","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"Created","TypeInfo@":{"value":"datetimeoffset"},"TypeMapping@":{"ClrType@":"System.DateTimeOffset","DbType@":27,"ProviderTypeName@":{"value":"datetimeoffset"},"ProviderType@":{"value":34}}}},{"key":"LessonId","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":true,"Name@":"LessonId","TypeInfo@":{"value":"uniqueidentifier"},"TypeMapping@":{"ClrType@":"System.Guid","DbType@":9,"ProviderTypeName@":{"value":"uniqueidentifier"},"ProviderType@":{"value":14}}}},{"key":"UseCredits","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"UseCredits","TypeInfo@":{"value":"bit"},"TypeMapping@":{"ClrType@":"System.Boolean","DbType@":3,"ProviderTypeName@":{"value":"bit"},"ProviderType@":{"value":2}}}},{"key":"UserId","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":true,"Name@":"UserId","TypeInfo@":{"value":"uniqueidentifier"},"TypeMapping@":{"ClrType@":"System.Guid","DbType@":9,"ProviderTypeName@":{"value":"uniqueidentifier"},"ProviderType@":{"value":14}}}}]}},{"Key":"dbo.Users","Value":{"serializedData":[{"key":"Activated","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":true,"IsPrimaryKey@":false,"Name@":"Activated","TypeInfo@":{"value":"datetimeoffset"},"TypeMapping@":{"ClrType@":"System.DateTimeOffset","DbType@":27,"ProviderTypeName@":{"value":"datetimeoffset"},"ProviderType@":{"value":34}}}},{"key":"ActivationKey","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"ActivationKey","TypeInfo@":{"value":"uniqueidentifier"},"TypeMapping@":{"ClrType@":"System.Guid","DbType@":9,"ProviderTypeName@":{"value":"uniqueidentifier"},"ProviderType@":{"value":14}}}},{"key":"CashReservationBlockedUntil","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":true,"IsPrimaryKey@":false,"Name@":"CashReservationBlockedUntil","TypeInfo@":{"value":"datetimeoffset"},"TypeMapping@":{"ClrType@":"System.DateTimeOffset","DbType@":27,"ProviderTypeName@":{"value":"datetimeoffset"},"ProviderType@":{"value":34}}}},{"key":"Credits","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"Credits","TypeInfo@":{"value":"int"},"TypeMapping@":{"ClrType@":"System.Int32","DbType@":11,"ProviderTypeName@":{"value":"int"},"ProviderType@":{"value":8}}}},{"key":"CreditsExpiration","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":true,"IsPrimaryKey@":false,"Name@":"CreditsExpiration","TypeInfo@":{"value":"datetimeoffset"},"TypeMapping@":{"ClrType@":"System.DateTimeOffset","DbType@":27,"ProviderTypeName@":{"value":"datetimeoffset"},"ProviderType@":{"value":34}}}},{"key":"Email","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"Email","TypeInfo@":{"value":"nvarchar(500)"},"TypeMapping@":{"ClrType@":"System.String","DbType@":16,"ProviderTypeName@":{"value":"nvarchar"},"ProviderType@":{"value":12}}}},{"key":"FirstName","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"FirstName","TypeInfo@":{"value":"nvarchar(50)"},"TypeMapping@":{"ClrType@":"System.String","DbType@":16,"ProviderTypeName@":{"value":"nvarchar"},"ProviderType@":{"value":12}}}},{"key":"Id","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":true,"Name@":"Id","TypeInfo@":{"value":"uniqueidentifier"},"TypeMapping@":{"ClrType@":"System.Guid","DbType@":9,"ProviderTypeName@":{"value":"uniqueidentifier"},"ProviderType@":{"value":14}}}},{"key":"LastName","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"LastName","TypeInfo@":{"value":"nvarchar(100)"},"TypeMapping@":{"ClrType@":"System.String","DbType@":16,"ProviderTypeName@":{"value":"nvarchar"},"ProviderType@":{"value":12}}}},{"key":"PasswordHash","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"PasswordHash","TypeInfo@":{"value":"nvarchar(80)"},"TypeMapping@":{"ClrType@":"System.String","DbType@":16,"ProviderTypeName@":{"value":"nvarchar"},"ProviderType@":{"value":12}}}},{"key":"PasswordResetKey","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":true,"IsPrimaryKey@":false,"Name@":"PasswordResetKey","TypeInfo@":{"value":"uniqueidentifier"},"TypeMapping@":{"ClrType@":"System.Guid","DbType@":9,"ProviderTypeName@":{"value":"uniqueidentifier"},"ProviderType@":{"value":14}}}},{"key":"Registered","value":{"HasDefault@":false,"IsAutonumber@":false,"IsNullable@":false,"IsPrimaryKey@":false,"Name@":"Registered","TypeInfo@":{"value":"datetimeoffset"},"TypeMapping@":{"ClrType@":"System.DateTimeOffset","DbType@":27,"ProviderTypeName@":{"value":"datetimeoffset"},"ProviderType@":{"value":34}}}}]}}],"Individuals@":[],"IsOffline@":true,"Packages@":[],"PrimaryKeys@":[{"Key":"dbo.Lessons","Value":{"head":"Id","tail":{"head":null,"tail":null}}},{"Key":"dbo.LessonReservations","Value":{"head":"LessonId","tail":{"head":"UserId","tail":{"head":null,"tail":null}}}},{"Key":"dbo.Users","Value":{"head":"Id","tail":{"head":null,"tail":null}}}],"Relationships@":[{"Key":"dbo.Lessons","Value":{"m_Item1":{"head":{"ForeignKey@":"LessonId","ForeignTable@":"dbo.LessonReservations","Name@":"FK_LessonReservations_Lessons","PrimaryKey@":"Id","PrimaryTable@":"dbo.Lessons"},"tail":{"head":null,"tail":null}},"m_Item2":{"head":null,"tail":null}}},{"Key":"dbo.LessonReservations","Value":{"m_Item1":{"head":null,"tail":null},"m_Item2":{"head":{"ForeignKey@":"LessonId","ForeignTable@":"dbo.LessonReservations","Name@":"FK_LessonReservations_Lessons","PrimaryKey@":"Id","PrimaryTable@":"dbo.Lessons"},"tail":{"head":{"ForeignKey@":"UserId","ForeignTable@":"dbo.LessonReservations","Name@":"FK_LessonReservations_Users","PrimaryKey@":"Id","PrimaryTable@":"dbo.Users"},"tail":{"head":null,"tail":null}}}}},{"Key":"dbo.Users","Value":{"m_Item1":{"head":{"ForeignKey@":"UserId","ForeignTable@":"dbo.LessonReservations","Name@":"FK_LessonReservations_Users","PrimaryKey@":"Id","PrimaryTable@":"dbo.Users"},"tail":{"head":null,"tail":null}},"m_Item2":{"head":null,"tail":null}}}],"SprocsParams@":[],"Sprocs@":[],"Tables@":[{"Key":"dbo.Lessons","Value":{"Name@":"Lessons","Schema@":"dbo","Type@":"base table"}},{"Key":"dbo.LessonReservations","Value":{"Name@":"LessonReservations","Schema@":"dbo","Type@":"base table"}},{"Key":"dbo.Workshops","Value":{"Name@":"Workshops","Schema@":"dbo","Type@":"base table"}},{"Key":"dbo.Users","Value":{"Name@":"Users","Schema@":"dbo","Type@":"base table"}},{"Key":"dbo._SchemaVersions","Value":{"Name@":"_SchemaVersions","Schema@":"dbo","Type@":"base table"}}]}