CREATE TABLE ATDC_ATTENDANCE_DETAIL (xid VARCHAR(64) NOT NULL, xdistributeFactor INTEGER, xabnormalDutyDayTime VARCHAR(32), xabsence DOUBLE, xabsentDayTime VARCHAR(32), xappealDescription CLOB(1M), xappealReason VARCHAR(64), xappealStatus INTEGER, xarchiveTime VARCHAR(32), xattendance DOUBLE, xbatchName VARCHAR(96), xcompanyName VARCHAR(254), xcreateTime TIMESTAMP, xcycleMonth VARCHAR(16), xcycleYear VARCHAR(16), xdepartmentName VARCHAR(254), xdescription VARCHAR(254), xempName VARCHAR(96), xempNo VARCHAR(96), xgetSelfHolidayDays DOUBLE, xisAbnormalDuty SMALLINT, xisAbsent SMALLINT, xisGetSelfHolidays SMALLINT, xisHoliday SMALLINT, xisLackOfTime SMALLINT, xisLate SMALLINT, xisLeaveEarlier SMALLINT, xisWeekend SMALLINT, xisWorkOvertime SMALLINT, xisWorkday SMALLINT, xlateTimeDuration BIGINT, xleaveEarlierTimeDuration BIGINT, xmonthString VARCHAR(16), xoffDutyTime VARCHAR(32), xoffWorkTime VARCHAR(32), xonDutyTime VARCHAR(32), xonWorkTime VARCHAR(32), xrecordDate TIMESTAMP, xrecordDateString VARCHAR(32), xrecordStatus INTEGER, xselfHolidayDayTime VARCHAR(32), xsequence VARCHAR(128), xupdateTime TIMESTAMP, xworkOvertimeTimeDuration BIGINT, xworkTimeDuration BIGINT, xyearString VARCHAR(16), PRIMARY KEY (xid));
CREATE INDEX ATDC_ATTENDANCE_DETAIL_createTime ON ATDC_ATTENDANCE_DETAIL (xcreateTime);
CREATE INDEX ATDC_ATTENDANCE_DETAIL_sequence ON ATDC_ATTENDANCE_DETAIL (xsequence);
CREATE INDEX ATDC_ATTENDANCE_DETAIL_updateTime ON ATDC_ATTENDANCE_DETAIL (xupdateTime);
