D3y0FmNg

1create table if not exists attendance_summary
2(
3	id integer default nextval('attendance_summary_id_seq'::regclass) not null
4		constraint attendance_summary_pk
5			primary key,
6	emp_id integer not null,
7	designation_id integer,
8	designation_category_id integer,
9	department_id integer,
10	office_id integer not null,
11	company_id integer not null,
12	shift_id integer not null,
13	emp_name varchar(100) not null,
14	profile_picture_url varchar(200),
15	email varchar(100) not null,
16	emp_office_id varchar(50),
17	office_admin boolean default false not null,
18	company_admin boolean default false not null,
19	include_in_att_report boolean default true not null,
20	allow_overtime boolean default false not null,
21	report_position integer,
22	designation_name varchar(50),
23	designation_category_name varchar(50),
24	department_name varchar(50),
25	office_name varchar(50) not null,
26	company_name varchar(50) not null,
27	year_of_att integer not null,
28	month_of_att integer not null,
29	date_of_att integer not null,
30	att_date_in_milliseconds bigint not null,
31	present boolean default false not null,
32	late boolean default false not null,
33	on_leave boolean default false not null,
34	holiday boolean default false not null,
35	offday boolean default false not null,
36	total_hour_present_in_millis bigint,
37	entry_time_in_millis bigint,
38	late_by_millis bigint,
39	exit_time_in_millis bigint,
40	overtime_hours_in_millis bigint,
41	shift_name varchar(50) not null,
42	shift_start_time varchar(50) not null,
43	shift_start_time_of_this_day_in_millis bigint not null,
44	shift_end_time varchar(50) not null,
45	shift_end_time_of_this_day_in_millis bigint not null,
46	late_count_start_time varchar(50),
47	late_count_start_time_of_this_day_in_millis bigint,
48	early_count_end_time varchar(50),
49	early_count_end_time_of_this_day_in_millis bigint,
50	shift_midnight_crossing boolean default false
51);
52
53alter table attendance_summary owner to root;
54
55create unique index if not exists attendance_summary_id_uindex
56	on attendance_summary (id);