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