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