project_seoul
Tables (11)
Ta_type_define (Untitled7)
- seq_log — int — Foreign key → log_data(time&attendance).seq_log — NOT NULL
- email — varchar2 — Foreign key → log_data(time&attendance).email — NOT NULL
- id — int — Foreign key → log_data(time&attendance).id — NOT NULL
- top (sub_get_in) — int
- mid (sub_get_back) — int
- bottom (sub_get_off) — int
activeLog (Untitled9)
- seq — int — Primary key — NOT NULL
- memberId — int
- name — String
- date — date
- action — String
- Field
log_data(time&attendance) (Untitled2)
- seq_log — int — Primary key — NOT NULL
- email — varchar2 — Foreign key → member.email — NOT NULL
- id — int — Foreign key → member.seq_id — NOT NULL
- type — int
- date
- state — int
- month — int
- day — int
log_event (Untitled4)
- seq_event — int — Primary key — NOT NULL
- email — varchar2 — Foreign key → member.email — NOT NULL
- id — int — Foreign key → member.seq_id — NOT NULL
- name
- type — int
- date (dayofuse) — date
- subject — varchar2
- body — varchar2
- state — int
- comment — varchar2
- reg_date (date) — date
- approver — String
member (Untitled)
- seq_id — int — Primary key — NOT NULL
- email — varchar2 — Primary key — NOT NULL
- name — varchar2
- dep — int
- exp_date — int
- permission — int
- stack — int
- late_stack (stack1) — int
notice_board (Untitled8)
- no — int
- type — string
- subject — String
- body — String
- name — String
- date — date
permission_define (Untitled3)
- AM (account_management) — int
- edit (content_modify) — int
- delete (content_delete) — int
- apply (content_apply) — int
- approval (content_approval) — int
- app_edit (approved_content_modify) — int
- app_delete (approved_content_delete) — int
- seq_id — int — Foreign key → member.seq_id — NOT NULL
- email — varchar2 — Foreign key → member.email — NOT NULL
progress (Untitled10)
- startDate (date) — date
- endDate (date1) — date
- totalCount (cnt) — int
- rate — double
state_define (Untitled6)
- wait (wait_for_approval) — int
- approval (approval_from_manager) — int
- reject (reject_from_manager) — int
- etc (result_from_manager) — int
- seq_event — int — Foreign key → log_event.seq_event — NOT NULL
- email — varchar2 — Foreign key → log_event.email — NOT NULL
- id — int — Foreign key → log_event.id — NOT NULL
timeTable_define (Untitled11)
- type — int — Primary key — NOT NULL
- hour — int
- SAH (Field) — int
- SAM (Field2) — int
- EAH (Field3) — int
- EAM (Field4) — int
- SBH (Field5) — int
- SBM (Field6) — int
- EBH (Field7) — int
- EBM (Field8) — int
- SLH (Field9) — int
- SLM (Field10) — int
- ELH (Field11) — int
- ELM (Field12) — int
type_define (Untitled5)
- report — int
- ap_half_1 (apply_AM_half_of_day) — int
- ap_half_2 (apply_PM_half_of_day) — int
- ap_full (apply_full_day) — int
- ap_w (apply_woman_day) — int
- ap_unpaid (apply_unpaid_day) — int
- ap_dis (apply_disease_day) — int
- ap_ov (apply_official_day) — int
- ap_el (apply_earlyleave_day) — int
- etc — int
- seq_event — int — Foreign key → log_event.seq_event — NOT NULL
- email — varchar2 — Foreign key → log_event.email — NOT NULL
- id (id2) — int — Foreign key → log_event.id — NOT NULL