더순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)