더순ERP

테이블 (15)

common_calendar (Untitled11)

  • id (Key) — int — 기본 키 — NOT NULL
  • date (Field2) — datetime — NOT NULL
  • note (Field) — varchar(255)
  • writer_id (id) — int(20) — 외래 키 → employee.id — NOT NULL

confirm_email (Untitled9)

  • id (Key) — int — 기본 키 — NOT NULL
  • admin_id (id) — int(20) — 외래 키 → employee.id — NOT NULL
  • date_expired (Field2) — timestamp — NOT NULL
  • email (Field3) — varchar(100) — NOT NULL
  • secured_key (Field4) — varchar(100) — NOT NULL

dept (CopyOfUntitled2)

  • id (Key) — int(20) — 기본 키 — NOT NULL
  • dept_name (Field2) — varchar(10) — NOT NULL

disbursement_report(지출결의서) (Untitled6)

  • id (Key) — int(20) — 기본 키 — NOT NULL
  • report_id (Key2) — int(20) — 외래 키 → report.id — NOT NULL
  • total_price (Field) — bigint — NOT NULL
  • total_price_korean (Field2) — varchar(20) — NOT NULL
  • evidence (Field3) — varchar(50)

disbursement_report_detail(지출결의서내역) (Untitled7)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • disbursement_report_id (Key2) — int(20) — 외래 키 → disbursement_report(지출결의서).id — NOT NULL
  • detail (Field2) — varchar(50) — NOT NULL
  • price (Field3) — bigint — NOT NULL
  • note (Field4) — varchar(50)

employee (Untitled)

  • id — int(20) — 기본 키 — NOT NULL
  • email (Field) — varchar(20) — NOT NULL
  • pwd (Field2) — varchar(20) — NOT NULL
  • name (Field3) — varchar(10) — NOT NULL
  • birth (Field4) — int(11)
  • dept_id (Key2) — int(20) — 외래 키 → dept.id
  • position_id (Key) — int(20) — 외래 키 → position.id
  • sign_id (Key3) — int(20) — 외래 키 → sign.id
  • role_id (Key4) — int — 외래 키 → role.id
  • sex (Field5) — tinytext
  • phone (Field6) — int(11)
  • admin_confirm (Field7) — varchar(2) — NOT NULL
  • reg_date (Field10) — tiemstramp — NOT NULL
  • modi_date (Field11) — timestamp — NOT NULL
  • use_yn (Field12) — varchar(2) — NOT NULL

position (Untitled2)

  • id (Key) — int(20) — 기본 키 — NOT NULL
  • position_name (Field2) — varchar(10) — NOT NULL

private_calendar (Untitled12)

  • id (Key) — int — 기본 키 — NOT NULL
  • date (Field) — datetime — NOT NULL
  • note_id (Key2) — int — 외래 키 → private_calendar_note.id — NOT NULL
  • writer_id (id) — int(20) — 외래 키 → employee.id — NOT NULL

private_calendar_note (Untitled13)

  • id (Key) — int — 기본 키 — NOT NULL
  • note (Field) — varchar(255)

report (Untitled3)

  • id (Key) — int(20) — 기본 키 — NOT NULL
  • report_type_id (Key2) — int(20) — 외래 키 → report_type.id — NOT NULL
  • reg_admin_id (id) — int(20) — 외래 키 → employee.id — NOT NULL
  • approval_id (id2) — int(20) — 외래 키 → employee.id — NOT NULL
  • title (Field) — varchar(50) — NOT NULL
  • reg_date (Field2) — timestamp — NOT NULL
  • mode_date (Field3) — tiemstamp — NOT NULL
  • approval_yn (Field4) — tinytext — NOT NULL
  • read_yn (Field5) — tinytext — NOT NULL
  • use_yn (Field6) — tinytext — NOT NULL

report_type (Untitled4)

  • id (Key) — int(20) — 기본 키 — NOT NULL
  • report_type_name (Field) — varchar(20) — NOT NULL

role (Untitled10)

  • id (Key) — int — 기본 키 — NOT NULL
  • authority (Field) — int — NOT NULL

sign (CopyOfCopyOfUntitled2)

  • id (Key) — int(20) — 기본 키 — NOT NULL
  • sign_name (Field2) — varchar(10) — NOT NULL
  • sign_image_path (Field) — NOT NULL

vacation_report (휴가신청서) (Untitled5)

  • id (Key) — int(20) — 기본 키 — NOT NULL
  • report_id (Key2) — int(20) — 외래 키 → report.id — NOT NULL
  • total_count (Field2) — int(10) — NOT NULL

vacation_report_detail(휴가상세내역) (Untitled8)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • vacation_report_id (Key2) — int(20) — 외래 키 → vacation_report (휴가신청서).id — NOT NULL
  • type (Field) — varchar(10) — NOT NULL
  • start_date (Field2) — timestamp — NOT NULL
  • end_date (Field3) — timestamp — NOT NULL
  • note (Field4) — varchar(100)