labworks
Tables (31)
budget_adjustments
- id — varchar(36) — Primary key — NOT NULL
- project_id — varchar(20) — NOT NULL
- date — date — NOT NULL
- amount — bigint(20) — NOT NULL
- status — varchar(50) — NOT NULL
- reason — text — NOT NULL
- from_category_id — int(11) — NOT NULL
- to_category_id — int(11) — NOT NULL
- requested_by — varchar(100)
- approved_by — varchar(100)
- comments — text
budget_categories
- id — int(11) — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- color — varchar(20)
budget_expenses
- id — varchar(36) — Primary key — NOT NULL
- project_id — varchar(20) — NOT NULL
- category_id — int(11) — NOT NULL
- date — date — NOT NULL
- amount — bigint(20) — NOT NULL
- status — varchar(50) — NOT NULL
- payment_method — varchar(50) — NOT NULL
- title — varchar(255) — NOT NULL
- vendor — varchar(255)
- description — text
- receipt_url — varchar(255)
budget_project_budgets
- id — int(11) — Primary key — NOT NULL
- project_id — varchar(20) — NOT NULL
- category_id — int(11) — NOT NULL
- original_amount — bigint(20) — NOT NULL
- current_amount — bigint(20) — NOT NULL
- used_amount — bigint(20) — NOT NULL
- description — text
budget_projects
- id — varchar(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- role — varchar(50) — NOT NULL
- participation_rate — int(11) — NOT NULL
- type — varchar(50) — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- budget — bigint(20) — NOT NULL
- is_three_to_five — tinyint(1) — NOT NULL
equipment_maintenance_log
- idx — int(11) — Primary key — NOT NULL
- equipment_idx — int(11) — NOT NULL — 장비 ID
- type — varchar(100) — NOT NULL — 유지보수 유형 (예: 정기 점검, 수리, 교정)
- maintenance_date — date — NOT NULL — 유지보수 날짜
- user — varchar(100) — NOT NULL — 유지보수 담당자
- notes — text — 유지보수 비고
- cost — decimal(10, 2) — 유지보수 비용
- status — enum('예정', '완료', '취소') — NOT NULL — 유지보수 상태
- reg_date — int(11) — NOT NULL
- mdy_date — int(11) — NOT NULL
- is_flag — tinyint(1) — NOT NULL
- memberIdx — varchar(100) — NOT NULL — 로그 등록자 회원 ID
- companyIdx — varchar(100) — NOT NULL
equipment_management
- idx — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL — 장비 명칭
- manufacturer — varchar(255) — NOT NULL — 제조사/브랜드
- model — varchar(255) — 모델/규격
- initial_quantity — decimal(10, 2) — NOT NULL — 초기 수량
- unit — varchar(20) — NOT NULL — 단위 (예: 개, 세트)
- current_quantity — decimal(10, 2) — NOT NULL — 현재 수량
- storage_location — varchar(255) — NOT NULL — 보관 위치
- purchase_date — date — 구매일자
- last_maintenance_date — date — 최종 유지보수일
- next_maintenance_date — date — 다음 유지보수 예정일
- equipment_status — enum('사용 가능', '점검 중', '수리 중', '폐기') — NOT NULL — 장비 상태
- user — varchar(100) — NOT NULL — 사용자
- description — text — 상세 설명
- reg_date — int(11) — NOT NULL
- mdy_date — int(11) — NOT NULL
- is_flag — tinyint(1) — NOT NULL
- memberIdx — varchar(100) — NOT NULL — 등록자 회원 ID
- companyIdx — varchar(100) — NOT NULL
equipment_reservation
- idx — int(11) — Primary key — NOT NULL
- equipment_idx — int(11) — NOT NULL — 장비 ID
- start_date — date — NOT NULL — 예약 시작 날짜
- end_date — date — NOT NULL — 예약 종료 날짜
- start_time — varchar(10) — NOT NULL — 예약 시작 시간 (예: 09:00)
- end_time — varchar(10) — NOT NULL — 예약 종료 시간 (예: 12:00)
- reserver — varchar(100) — NOT NULL — 예약자
- purpose — text — 예약 목적
- status — enum('승인 대기', '승인', '사용 중', '완료', '취소') — NOT NULL — 예약 상태
- reg_date — int(11) — NOT NULL
- mdy_date — int(11) — NOT NULL
- is_flag — tinyint(1) — NOT NULL
- memberIdx — varchar(100) — NOT NULL — 예약자 회원 ID
- companyIdx — varchar(100) — NOT NULL
kpi_goal
- id — int(11) — Primary key — NOT NULL
- year — int(11) — NOT NULL
- kpi_type — varchar(50) — NOT NULL
- target_value — int(11) — NOT NULL
- description — text
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
kpi_types
- idx — int(11) — Primary key — NOT NULL
- name — varchar(100)
- description — text
- unit — varchar(50)
- created_at — datetime
- updated_at — datetime
manage_organizations
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- member_idx — varchar(100)
- member_name — varchar(255)
- company_idx — varchar(100)
- company_name — varchar(255)
- reg_date — int(10)
- mdy_date — int(10)
- is_flag — int(11)
manage_pi
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- member_idx — varchar(100)
- member_name — varchar(255)
- company_idx — varchar(100)
- company_name — varchar(255)
- reg_date — int(10)
- mdy_date — int(10)
- is_flag — int(11)
manage_projects
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- type — enum('planning','application','ongoing') — NOT NULL
- organization — varchar(255) — NOT NULL
- pi_name — varchar(100) — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- budget — bigint(20)
- description — text
- status — enum('기획중','신청완료','진행중','마감임박') — NOT NULL
- member_idx — varchar(100)
- member_name — varchar(255)
- company_idx — varchar(100)
- company_name — varchar(255)
- is_flag — int(11)
- reg_date — int(10)
- mdy_date — int(10)
manage_researchers
- id — int(11) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- department — varchar(100) — NOT NULL
- position — varchar(100) — NOT NULL
- email — varchar(255) — NOT NULL
- phone — varchar(50) — NOT NULL
- age — int(11)
- gender — enum('남성','여성')
- degree — varchar(100)
- lab — varchar(200)
- lab_url — varchar(500)
- education — json
- research_areas — json
- publications — json
- patents — json
- awards — json
- status — enum('active','inactive')
- deleted_at — timestamp
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
meeting_types
- id — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- createdAt — datetime
- updatedAt — datetime
meetings
- id — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- date — datetime — NOT NULL
- startTime — varchar(255) — NOT NULL
- endTime — varchar(255) — NOT NULL
- location — varchar(255) — NOT NULL
- attendees — varchar(255) — NOT NULL
- status — varchar(255) — NOT NULL
- agenda — text
- content — text
- typeId — int(11) — NOT NULL
- createdAt — datetime
- updatedAt — datetime
patent_management
- idx — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- title_en — varchar(255)
- application_number — varchar(50) — NOT NULL
- registration_number — varchar(50)
- application_date — date
- registration_date — date
- ipc_classification — varchar(100)
- inventors — varchar(255) — NOT NULL
- applicant — varchar(255) — NOT NULL
- status — enum('출원','심사중','등록','거절') — NOT NULL
- technology_transfer — enum('이전완료','희망','비희망') — NOT NULL
- abstract — text
- summary — text
- keywords — text
- invention_info — json
- tech_info — json
- reg_date — int(11) — NOT NULL
- mdy_date — int(11) — NOT NULL
- is_flag — tinyint(1) — NOT NULL
- memberIdx — varchar(100) — NOT NULL
- companyIdx — varchar(100) — NOT NULL
project_planning
- id — bigint(20) — Primary key — NOT NULL
- project_name — varchar(255) — NOT NULL — 사업명
- project_manager — varchar(100) — NOT NULL — 총괄책임자
- start_date — date — NOT NULL — 사업 시작일
- end_date — date — NOT NULL — 사업 종료일
- department — varchar(100) — NOT NULL — 주관부처
- institution — varchar(100) — NOT NULL — 전문기관
- total_cost — bigint(20) — NOT NULL — 총사업비
- is_final_performer — tinyint(1) — 최종수행원 여부
- announcement_link — text — 공고문 링크
- attachment_files — json — 첨부파일 정보 (파일명, 경로, 크기 등)
- project_purpose — text — 사업목적
- project_details — text — 사업내용
- policy_goals — json — 정책목표 리스트 {policy_name, target_value, achievement_rate}
- consortium_members — json — 컨소시엄 구성원 리스트 {type, name_position_contact, role_description}
- business_plan_files — json — 사업계획서 파일들 {doc_type, file_path, upload_date}
- result_report_files — json — 결과보고서 파일들 {doc_type, file_path, upload_date}
- created_by — varchar(100) — 생성자
- status — enum('DRAFT', 'SUBMITTED', 'APPROVED', 'REJECTED') — 상태
- member_idx — bigint(20)
- member_name — varchar(100)
- company_idx — bigint(20)
- company_name — varchar(255)
- reg_date — int(10)
- mdy_date — int(10)
- is_flag — int(11)
reagent_inventory_log
- idx — int(11) — Primary key — NOT NULL
- reagent_idx — int(11) — NOT NULL — 시약 ID
- type — enum('입고', '출고') — NOT NULL — 입고/출고 구분
- quantity — decimal(10, 2) — NOT NULL — 수량
- unit — varchar(20) — NOT NULL — 단위
- log_date — date — NOT NULL — 입출고 날짜
- user — varchar(100) — NOT NULL — 사용자
- notes — text — 비고
- reg_date — int(11) — NOT NULL
- mdy_date — int(11) — NOT NULL
- is_flag — tinyint(1) — NOT NULL
- memberIdx — varchar(100) — NOT NULL — 로그 등록자 회원 ID
- companyIdx — varchar(100) — NOT NULL
reagent_management
- idx — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL — 시약명
- manufacturer — varchar(255) — NOT NULL — 제조사
- model — varchar(255) — 모델/규격
- initial_quantity — decimal(10, 2) — NOT NULL — 초기 수량
- unit — varchar(20) — NOT NULL — 단위 (ml, g, mg 등)
- current_stock — decimal(10, 2) — NOT NULL — 현재 재고
- min_stock — decimal(10, 2) — NOT NULL — 최소 재고 (알림 기준)
- storage_location — varchar(255) — NOT NULL — 보관 위치
- purchase_date — date — 구매일자
- expiry_date — date — 유효기간
- user — varchar(100) — NOT NULL — 사용자
- description — text — 상세 설명
- reg_date — int(11) — NOT NULL
- mdy_date — int(11) — NOT NULL
- is_flag — tinyint(1) — NOT NULL
- memberIdx — varchar(100) — NOT NULL — 등록자 회원 ID
- companyIdx — varchar(100) — NOT NULL
reagent_stock_alert
- idx — int(11) — Primary key — NOT NULL
- reagent_idx — int(11) — NOT NULL — 시약 ID
- alert_type — enum('재고부족', '유통기한') — NOT NULL — 알림 유형
- threshold — decimal(10, 2) — NOT NULL — 임계값
- is_active — tinyint(1) — NOT NULL — 알림 활성화 여부
- last_alert_date — datetime — 마지막 알림일
- notes — text — 비고
- reg_date — int(11) — NOT NULL
- mdy_date — int(11) — NOT NULL
- is_flag — tinyint(1) — NOT NULL
- memberIdx — varchar(100) — NOT NULL
- companyIdx — varchar(100) — NOT NULL
report_history
- id — int(11) — Primary key — NOT NULL
- report_type — varchar(50) — NOT NULL
- project_name — varchar(500) — NOT NULL
- created_date — date — NOT NULL
- author_name — varchar(100) — NOT NULL
- company_idx — varchar(50)
- company_name — varchar(200)
- member_idx — varchar(50)
- member_name — varchar(100)
- project_overview — text
- research_process — text
- research_results — text
- annual_next_year_goals — text
- annual_environment_changes — text
- annual_research_strategy — text
- annual_schedule_and_expectations — text
- annual_budget_plan — text
- annual_commercialization_plan — text
- annual_utilization_and_effects — text
- progress_self_analysis — text
- progress_self_improvement_activities — text
- progress_contribution_to_related_fields — text
- progress_important_research_changes — text
- progress_next_stage_goals — text
- progress_next_stage_environment_changes — text
- progress_next_stage_research_strategy — text
- progress_next_stage_schedule_and_expectations — text
- progress_next_stage_budget_plan — text
- progress_next_stage_commercialization_plan — text
- progress_next_stage_utilization_and_effects — text
- final_self_analysis — text
- final_self_improvement_activities — text
- final_contribution_to_related_fields — text
- final_management_and_utilization_plan — text
- additional_data — json
- is_draft — tinyint(1)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
report_templates
- id — varchar(50) — Primary key — NOT NULL
- type — varchar(20) — NOT NULL — 보고서 타입 (annual, progress, performance, budget, results)
- title — varchar(255) — NOT NULL — 템플릿 제목
- description — text — 템플릿 설명
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
reports
- id — varchar(50) — Primary key — NOT NULL
- template_id — varchar(50) — NOT NULL
- title — varchar(255) — NOT NULL — 보고서 제목
- start_date — date — NOT NULL — 시작일
- end_date — date — NOT NULL — 종료일
- researcher — varchar(100) — NOT NULL — 연구자명
- file_format — varchar(10) — 파일 형식 (pdf, excel, word, ocx, hwp)
- author_idx — varchar(100) — 작성자 인덱스
- author_name — varchar(100) — 작성자명
- company_idx — varchar(100) — 회사 인덱스
- objectives — text — 연구 목표
- methods — text — 연구 방법
- results — text — 연구 결과
- conclusion — text — 결론
- future — text — 향후 연구 계획
- progress_percent — int(11) — 진행률 (0-100)
- achievements — text — 주요 성과
- challenges — text — 문제점 및 해결 방안
- next_steps — text — 다음 단계 계획
- summary — text — 성과 요약
- publications — json — 논문 정보 (JSON 배열)
- patents — json — 특허 정보 (JSON 배열)
- presentations — json — 학회 발표 정보 (JSON 배열)
- total_budget — varchar(50) — 총 예산
- used_budget — varchar(50) — 사용 예산
- remaining_budget — varchar(50) — 잔여 예산
- personnel — varchar(50) — 인건비
- equipment — varchar(50) — 장비비
- materials — varchar(50) — 재료비
- travel — varchar(50) — 출장비
- others — varchar(50) — 기타
- notes — text — 비고
- executed_budget — decimal(15, 2) — 집행 예산
- budget_categories — json — 예산 항목별 세부 내역
- justification — text — 집행 근거 및 사유
- research_summary — text — 연구 요약
- research_objectives — text — 연구 목표
- research_achievements — text — 주요 성과
- impact — text — 연구 영향력
- future_direction — text — 향후 연구 방향
- final_conclusion — text — 최종 결론
- achievements_final — text — 최종 성과
- evaluation — text — 평가 및 결론
- limitations — text — 한계점
- recommendations — text — 제언 및 권고사항
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
research_log
- id — int(11) — Primary key — NOT NULL
- date — date — NOT NULL
- title — varchar(255) — NOT NULL
- author — varchar(100) — NOT NULL
- project_title — varchar(255) — NOT NULL
- file_count — int(11)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
research_output
- idx — int(11) — Primary key — NOT NULL
- type — varchar(50) — NOT NULL
- title — varchar(255) — NOT NULL
- titleEn — varchar(255)
- authors — varchar(255) — NOT NULL
- affiliation — varchar(255)
- contact — varchar(100)
- regDate — varchar(20) — NOT NULL
- publisher — varchar(255) — NOT NULL
- project — varchar(255) — NOT NULL
- abstract — text
- summary — text
- keywords — text
- mainWords — text
- files — text
- reg_date — timestamp — NOT NULL
- mdy_date — timestamp — NOT NULL
- is_flag — tinyint(1)
- memberIdx — varchar(100) — NOT NULL
- companyIdx — varchar(100) — NOT NULL
research_record
- id — int(11) — Primary key — NOT NULL
- record_date — date — NOT NULL
- title — varchar(255) — NOT NULL
- content — text
- author_id — int(11)
- project_id — int(11)
- file_path — varchar(512)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- author — varchar(100)
- project_title — varchar(255)
- experiment_type — varchar(100)
- experiment_location — varchar(255)
- participants — text
- start_time — time
- end_time — time
- experiment_conditions — text
schedule_announcements
- id — int(11) — Primary key — NOT NULL
- member_idx — varchar(100) — NOT NULL
- member_name — varchar(100) — NOT NULL
- company_idx — varchar(100) — NOT NULL
- company_name — varchar(100) — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- important — tinyint(1)
- last_editor — varchar(100)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
schedule_projects
- id — int(11) — Primary key — NOT NULL
- project_name — varchar(100) — NOT NULL
- description — text
- member_idx — varchar(100) — NOT NULL
- member_name — varchar(100) — NOT NULL
- company_idx — varchar(100) — NOT NULL
- company_name — varchar(100) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
schedule_schedules
- id — int(11) — Primary key — NOT NULL
- member_idx — varchar(100) — NOT NULL
- member_name — varchar(100) — NOT NULL
- company_idx — varchar(100) — NOT NULL
- company_name — varchar(100) — NOT NULL
- title — varchar(255) — NOT NULL
- category — varchar(255)
- description — text
- start_date — datetime — NOT NULL
- end_date — datetime
- is_all_day — tinyint(1)
- location — varchar(255)
- participants — text
- project_id — int(11) — NOT NULL
- type_id — int(11) — NOT NULL
- last_editor — varchar(100)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
schedule_types
- id — int(11) — Primary key — NOT NULL
- category — varchar(100) — NOT NULL
- color — varchar(100) — NOT NULL
- member_idx — varchar(100) — NOT NULL
- member_name — varchar(100) — NOT NULL
- company_idx — varchar(100) — NOT NULL
- company_name — varchar(100) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp