public StudentTable()
: base("STUDENT")
{
AddColumn(new BigIntColumn("student_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new StringColumn("title", ColumnConstants.StrLenStaffStudentTitle));
AddColumn(new Ct7SexColumn());
AddColumn(new DateTimeColumn("dob"));
AddColumn(ColumnUtils.CreateAddressColumns());
AddColumn(ColumnUtils.CreateRoomIdAndNameColumns());
AddColumn(new Ct7AcademicYearColumn());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaffIdAndNameColumns());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new StringColumn("card_num", ColumnConstants.StrLenStd));
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(ColumnUtils.CreateSchedulableColumn());
AddColumn(ColumnUtils.CreateStdTelColumns());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new StringColumn("profile", ColumnConstants.StrLenStd));
AddColumn(new StringColumn("photo_file", ColumnConstants.StrLenPhotoFile));
AddColumn(ColumnUtils.CreateSpecialNeedsColumns());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("student_id");
AddUniqueNameIndex();
AddNameIndex();
}
public EventInstanceTable()
: base("EVENT_INSTANCE")
{
AddColumn(new NotNullStringColumn("event_instance_id", ColumnConstants.StrLenEventInstance));
AddColumn(new BigIntColumn("event_id", ColumnNullable.False));
AddColumn(new BigIntColumn("timetable_id", ColumnNullable.False));
AddColumn(new BigIntColumn("timetable_event_id", ColumnNullable.False));
AddColumn(new IntColumn("timetable_week", ColumnNullable.False));
AddColumn(new IntColumn("timetable_occurrence", ColumnNullable.False));
AddColumn(new StringColumn("event_name", ColumnConstants.StrLenStd));
AddColumn(new IntColumn("day_of_week", ColumnNullable.False));
AddColumn(new DateTimeColumn("start_time", ColumnNullable.False));
AddColumn(new DateTimeColumn("end_time", ColumnNullable.False));
AddColumn(new IntColumn("break_mins"));
AddColumn(ColumnUtils.CreateSpanIdAndNameColumns());
AddColumn(ColumnUtils.CreateEventCatIdAndNameColumns());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new IntColumn("capacity_req"));
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(new BitColumn("global_event"));
AddColumn(new BitColumn("protected"));
AddColumn(new BitColumn("suspended"));
AddColumn(new IntColumn("grouping_id"));
AddColumn(new BitColumn("registers_req", ColumnNullable.True));
AddColumn(new BitColumn(ColumnConstants.RegistersReqResolvedColumnName));
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("event_instance_id");
}
public RoomTable()
: base("ROOM")
{
AddColumn(new BigIntColumn("room_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateSiteIdAndNameColumns());
AddColumn(new FloatColumn("area"));
AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(ColumnUtils.CreateSchedulableColumn());
AddColumn(new IntColumn("default_capacity"));
AddColumn(new FloatColumn("charge"));
AddColumn(new Ct7TelephoneColumn());
AddColumn(new Ct7WebColumn());
AddColumn(ColumnUtils.CreateSpecialNeedsColumns());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("room_id");
AddUniqueNameIndex();
AddNameIndex();
}
public GroupTable()
: base("GROUP")
{
AddColumn(new BigIntColumn("group_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new Ct7AcademicYearColumn());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(new IntColumn("target_size"));
AddColumn(new IntColumn("group_size"));
AddColumn(new IntColumn("additional"));
AddColumn(new IntColumn("split_id"));
AddColumn(ColumnUtils.CreateSchedulableColumn());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("group_id");
AddUniqueNameIndex();
AddNameIndex();
}
public StaffTable()
: base("STAFF")
{
AddColumn(new BigIntColumn("staff_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new StringColumn("title", ColumnConstants.StrLenStaffStudentTitle));
AddColumn(new Ct7SexColumn());
AddColumn(ColumnUtils.CreateAddressColumns());
AddColumn(ColumnUtils.CreateRoomIdAndNameColumns());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new IntColumn("allowance_week"));
AddColumn(new IntColumn("allowance_total"));
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(ColumnUtils.CreateSchedulableColumn());
AddColumn(ColumnUtils.CreateStdTelColumns());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new StringColumn("profile", ColumnConstants.StrLenStd));
AddColumn(ColumnUtils.CreateSpecialNeedsColumns());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("staff_id");
AddUniqueNameIndex();
AddNameIndex();
}
public ExamTable()
: base("EXAM")
{
AddColumn(new BigIntColumn("exam_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new BigIntColumn("session_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("session_name"));
AddColumn(new IntColumn("duration"));
AddColumn(ColumnUtils.CreateEventCatIdAndNameColumns());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new IntColumn("capacity_req"));
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(new BitColumn("protected"));
AddColumn(new BitColumn("suspended"));
AddColumn(new IntColumn("grouping_id"));
AddColumn(new BitColumn("registers_req", ColumnNullable.True));
AddColumn(new Ct7BoolColumn(ColumnConstants.RegistersReqResolvedColumnName));
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("exam_id");
}
public AuxTimeTable()
: base("AUX_TIME")
{
AddColumn(new BigIntColumn("activity_id", ColumnNullable.False));
AddColumn(new BigIntColumn("student_id", ColumnNullable.False));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumnsWithName(ColumnNullable.False));
AddColumn(ColumnUtils.CreateAuditColumnsWithNames(ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn("student_unique_name"));
AddColumn(new Ct7NameColumn("student_name"));
AddPrimaryKey("activity_id", "student_id", "resource_type", "resource_id");
}
public AuxMarkTable()
: base("AUX_MARK")
{
AddColumn(new BigIntColumn("student_id", ColumnNullable.False));
AddColumn(ColumnUtils.CreateResourceTypeAndIdColumnsWithName(ColumnNullable.False));
AddColumn(ColumnUtils.CreateAuditColumnsWithNames(ColumnNullable.False));
AddColumn(ColumnUtils.CreateCustomColumns(2));
AddColumn(new Ct7UniqueNameColumn("student_unique_name"));
AddColumn(new Ct7NameColumn("student_name"));
AddPrimaryKey("student_id", "resource_type", "resource_id", "date_change");
}
public StaffCatTable()
: base("STAFF_CAT")
{
AddColumn(new BigIntColumn("staff_cat_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("name"));
AddColumn(new Ct7DescriptionColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("staff_cat_id");
AddNameIndex();
}
public FixtureTable()
: base("FIXTURE")
{
AddColumn(new BigIntColumn("fixture_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("name"));
AddColumn(new Ct7DescriptionColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("fixture_id");
AddNameIndex();
}
public NotificationTable()
: base("NOTIFICATION")
{
AddColumn(new BigIntColumn("message_id", ColumnNullable.False));
AddColumn(new BigIntColumn("student_id", ColumnNullable.False));
AddColumn(new BigIntColumn("activity_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("msg_text", ColumnConstants.StrLenDescription));
AddColumn(new BitColumn("sent"));
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(new Ct7UniqueNameColumn("student_unique_name"));
AddColumn(new Ct7NameColumn("student_name"));
AddPrimaryKey("message_id");
}
public AttendTimeTable()
: base("ATTEND_TIME")
{
AddColumn(new BigIntColumn("attend_time_id", ColumnNullable.False));
AddColumn(new BigIntColumn("activity_id", ColumnNullable.False));
AddColumn(new BigIntColumn("student_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn("student_unique_name"));
AddColumn(new Ct7NameColumn("student_name"));
AddColumn(new DateTimeColumn("in_time", ColumnNullable.False));
AddColumn(new DateTimeColumn("out_time", ColumnNullable.False));
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddPrimaryKey("attend_time_id");
}
public LayoutTable()
: base("LAYOUT")
{
AddColumn(new BigIntColumn("room_layout_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("name"));
AddColumn(new Ct7DescriptionColumn());
AddColumn(new BitColumn("complex"));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("room_layout_id");
AddNameIndex();
}
public EventCatTable()
: base("EVENT_CAT")
{
AddColumn(new BigIntColumn("event_cat_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("name"));
AddColumn(new Ct7DescriptionColumn());
AddColumn(new IntColumn("colour"));
AddColumn(new FloatColumn("weighting"));
AddColumn(new BitColumn("registers_req", ColumnNullable.True));
AddColumn(new BitColumn(ColumnConstants.RegistersReqResolvedColumnName, ColumnNullable.True));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("event_cat_id");
}
public AttendTable()
: base("ATTEND")
{
AddColumn(new BigIntColumn("attend_id", ColumnNullable.False));
AddColumn(new BigIntColumn("activity_id", ColumnNullable.False));
AddColumn(new BigIntColumn("student_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn("student_unique_name"));
AddColumn(new Ct7NameColumn("student_name"));
AddColumn(new BigIntColumn("mark_id"));
AddColumn(new Ct7NameColumn("mark_name"));
AddColumn(new IntColumn("mins_late"));
AddColumn(new StringColumn("comments", ColumnConstants.StrLenComments));
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddPrimaryKey("attend_id");
}
public SiteTable()
: base("SITE")
{
AddColumn(new BigIntColumn("site_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("name"));
AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames());
AddColumn(new Ct7TelephoneColumn());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("site_id");
AddNameIndex();
}
public WeekSchemeTable()
: base("WEEK_SCHEME")
{
AddColumn(new BigIntColumn("week_scheme_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("name"));
for (int n = 0; n < MiscSchema.MaxWeeksInTimetable; ++n)
{
var colName = string.Concat("week_number", n + 1);
AddColumn(new StringColumn(colName, ColumnConstants.StrLenStd));
}
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddPrimaryKey("week_scheme_id");
}
public CourseTable()
: base("COURSE")
{
AddColumn(new BigIntColumn("course_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("name"));
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames());
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("course_id");
AddNameIndex();
}
public UserTable()
: base("TIMETABLE_USER")
{
AddColumn(new BigIntColumn("user_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("name"));
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaffIdAndNameColumns());
AddColumn(ColumnUtils.CreateStudentIdAndNameColumns());
AddColumn(new BitColumn("active"));
AddColumn(new Ct7EmailColumn());
AddColumn(new BitColumn("booking_admin"));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddPrimaryKey("user_id");
}
public FacultyTable()
: base("FACULTY")
{
AddColumn(new BigIntColumn("faculty_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("name"));
AddColumn(new IntColumn("colour"));
AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames());
AddColumn(new Ct7TelephoneColumn());
AddColumn(new Ct7EmailColumn());
AddColumn(new Ct7WebColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("faculty_id");
AddNameIndex();
}
public SupervisorTable()
: base("SUPERVISOR")
{
AddColumn(new BigIntColumn("supervisor_id", ColumnNullable.False));
AddColumn(new Ct7NameColumn());
AddColumn(new StringColumn("business_name", ColumnConstants.StrLenStd));
AddColumn(new Ct7TelephoneColumn("mobile"));
AddColumn(new Ct7EmailColumn());
AddColumn(new BitColumn("can_send_sms"));
AddColumn(new BitColumn("can_send_email"));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("supervisor_id");
AddNameIndex();
}
public RegisterMarkTable()
: base("REGISTER_MARK")
{
AddColumn(new BigIntColumn("student_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("event_instance_id", ColumnConstants.StrLenEventInstance));
AddColumn(new BigIntColumn("event_id", ColumnNullable.False));
AddColumn(new IntColumn("timetable_week", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn("student_unique_name"));
AddColumn(new Ct7NameColumn("student_name"));
AddColumn(new BigIntColumn("mark_id"));
AddColumn(new Ct7NameColumn("mark_name"));
AddColumn(new IntColumn("mins_late"));
AddColumn(new StringColumn("comments", ColumnConstants.StrLenComments));
AddColumn(new FixedCharColumn("source", 1));
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddPrimaryKey("student_id", "event_instance_id");
}
public ActivityTable()
: base("ACTIVITY")
{
AddColumn(new BigIntColumn("activity_id", ColumnNullable.False));
AddColumn(new NotNullStringColumn("event_instance_id", ColumnConstants.StrLenEventInstance));
AddColumn(new BigIntColumn("event_id", ColumnNullable.False));
AddColumn(new IntColumn("timetable_week", ColumnNullable.False));
AddColumn(new DateTimeColumn("start_datetime", ColumnNullable.False));
AddColumn(new DateTimeColumn("end_datetime", ColumnNullable.False));
AddColumn(new BitColumn("closed"));
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateStaffIdAndNameColumns());
AddColumn(new BitColumn("staff_present"));
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("activity_id");
}
public TeamTable()
: base("TEAM")
{
AddColumn(new BigIntColumn("team_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(ColumnUtils.CreateSchedulableColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("team_id");
AddUniqueNameIndex();
AddNameIndex();
}
public BookingTable()
: base("BOOKING")
{
AddColumn(new BigIntColumn("booking_id", ColumnNullable.False));
AddColumn(new NullStringColumn("title"));
AddColumn(ColumnUtils.CreateUserIdAndNameColumns());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(new Ct7NotesColumn("search_criteria"));
AddColumn(ColumnUtils.CreateEventCatIdAndNameColumns());
AddColumn(new NullStringColumn("requester_name"));
AddColumn(new NullStringColumn("requester_email"));
AddColumn(new BitColumn("add_me"));
AddColumn(new IntColumn("status", ColumnNullable.False));
AddColumn(new Ct7NotesColumn());
AddColumn(new Ct7NotesColumn("audit_notes"));
AddColumn(new IntColumn("sb_status"));
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("booking_id");
}
public ModuleTable()
: base("MODULE")
{
AddColumn(new BigIntColumn("module_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(new Ct7AcademicYearColumn());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(ColumnUtils.CreateTargetColumns());
AddColumn(ColumnUtils.CreateSchedulableColumn());
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("module_id");
AddUniqueNameIndex();
AddNameIndex();
}
public EquipTable()
: base("EQUIP")
{
AddColumn(new BigIntColumn("equip_id", ColumnNullable.False));
AddColumn(new Ct7UniqueNameColumn());
AddColumn(new Ct7NameColumn());
AddColumn(ColumnUtils.CreateDeptIdAndNameColumns());
AddColumn(ColumnUtils.CreateFacultyIdAndNameColumns());
AddColumn(ColumnUtils.CreateStaff1And2ColumnsWithNames());
AddColumn(ColumnUtils.CreateCustomColumns());
AddColumn(new IntColumn("booking_interval"));
AddColumn(ColumnUtils.CreateSchedulableColumn());
AddColumn(new FloatColumn("charge"));
AddColumn(new Ct7WebColumn());
AddColumn(new Ct7NotesColumn());
AddColumn(ColumnUtils.CreateLookupColumns());
AddColumn(ColumnUtils.CreateAuditColumnsWithNames());
AddColumn(ColumnUtils.CreateOriginColumns());
AddPrimaryKey("equip_id");
AddUniqueNameIndex();
AddNameIndex();
}
