private IDBTable Claim(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("Claim", sch, rev); ret.AddField("Name", DBMacros.DBFieldNazivDescriptor(false), rev); return(ret); }
private IDBTable Organization(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("Organization", sch, new DBRevision(rev)); ret.AddField("Name", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); return(ret); }
private IDBTable Principal(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("Principal", sch, rev); ret.AddField("Username", DBMacros.DBFieldNazivDescriptor(false), rev); ret.AddField("SuperAdmin", DBMacros.DBFieldBitDescriptor(false), rev); return(ret); }
private IDBTable BusinessDay(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("BusinessDay", sch, new DBRevision(rev)); ret.AddField("ShortName", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddField("FullName", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddConstraint(new DBUniqueConstraintDescriptor("ShortName"), new DBRevision(rev)); ret.AddConstraint(new DBUniqueConstraintDescriptor("FullName"), new DBRevision(rev)); return(ret); }
private IDBTable LinePhoto(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("LinePhoto", sch, new DBRevision(rev)); DBMacros.AddForeignKeyFieldID("LineID", false, ret, sch.Name + ".Line", new DBRevision(rev)); ret.AddField("PhotoName", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddField("PhotoUrl", DBMacros.DBFieldLongTextDescriptor(false), new DBRevision(rev)); return(ret); }
private IDBTable LineLocation(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("LineLocation", sch, new DBRevision(rev)); ret.AddField("Longitude", new DBFieldDescriptor() { Size = 18, Precision = 6, FieldType = new DBFieldTypeDecimal(), DefaultValue = "0", Nullable = false }, new DBRevision(rev)); ret.AddField("Latitude", new DBFieldDescriptor() { Size = 18, Precision = 6, FieldType = new DBFieldTypeDecimal(), DefaultValue = "0", Nullable = false }, new DBRevision(rev)); DBMacros.AddForeignKeyFieldID("CountryID", false, ret, sch.Name + ".Country", new DBRevision(rev)); ret.AddField("StreetAddress", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddField("City", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddField("State", DBMacros.DBFieldNazivDescriptor(true), new DBRevision(rev)); ret.AddField("ZipCode", DBMacros.DBFieldNazivDescriptor(true), new DBRevision(rev)); ret.AddConstraint(new DBForeignKeyConstraintDescriptor(new List <string>() { "ID" }, sch.Name + ".Line", new List <string>() { "ID" }), new DBRevision(rev)); return(ret); }
private IDBTable Line(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 1, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("Line", sch, new DBRevision(rev)); var fldName = ret.AddField("Name", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); fldName.AddRevision(new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Delete)); ret.AddField("Title", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); ret.AddField("Description", DBMacros.DBFieldLongTextDescriptor(false), new DBRevision(rev)); DBMacros.AddForeignKeyFieldID("OrganizationID", false, ret, sch.Name + ".Organization", new DBRevision(rev)); return(ret); }
private IDBTable LineEmployeeInvited(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 3, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("LineEmployeeInvited", sch, new DBRevision(rev)); ret.AddConstraint(new DBForeignKeyConstraintDescriptor(new List <string>() { "ID" }, sch.Name + ".LineEmployee", new List <string>() { "ID" }), new DBRevision(rev)); ret.AddField("InviteSentOn", DBMacros.DBFieldDateTimeDescriptor(false), new DBRevision(rev)); ret.AddField("InviteEmail", DBMacros.DBFieldNazivDescriptor(false), new DBRevision(rev)); return(ret); }