tuning
Tables (3)
pay
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- pay — int
- create_dt — datetime — NOT NULL
- update_dt — datetime — NOT NULL
- delete_dt — datetime
user
- id — int — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- user_login_id — varchar(30) — NOT NULL
- user_login_pw — varchar(50) — NOT NULL
- user_create_dt — datetime — NOT NULL
- user_update_dt — datetime — NOT NULL
- user_delete_dt — datetime
work_time
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
- in_time — datetime
- out_time — datetime
- status — tinyint — NOT NULL
- work_date — date — NOT NULL