wecommit
Tables (15)
Company
- id — INTEGER
- businessNumber — Not Null
- name — TEXT — NOT NULL
- description — TEXT
- address — TEXT — NOT NULL
- category — TEXT — NOT NULL
- 매출규모 (revenue) — Not Null
- 지원 사업명 (supportedPrograms) — Not Null
- 소재 지역 (location) — Not Null
- 대표자 나이 (representativeAge) — Not Null
- 고용 인원 (employeeCount) — Not Null
- userId — Not Null — Foreign key → User.userId — NOT NULL
CompanyDetail
- id — INTEGER
- company_id — INTEGER — Foreign key → Company.id
- sector_code — TEXT — NOT NULL
- business_registration_number — TEXT — NOT NULL
- corporate_registration_number — TEXT
- type — TEXT
- revenue_size — INTEGER
- postal_code — TEXT
- phone_number — TEXT
- email — TEXT — NOT NULL
- signature_path — TEXT — NOT NULL
- age — INTEGER
- bank_name — TEXT
- bank_account_owner — TEXT
- bank_account_number — TEXT
- employee_number — INTEGER
- size — TEXT
- logo_path — TEXT
- website — TEXT
- id (id2) — INTEGER — Foreign key
Company_Team
- id — INTEGER
- companyDetail_id — INTEGER — Foreign key → CompanyDetail.id
- id (id2) — INTEGER — Foreign key → CompanyDetail.id
Document
- id — INTEGER — Primary key
- name — VARCHAR — NOT NULL
- type — VARCHAR
- created_at — TIMESTAMP
- creator_id — VARCHAR
- original_file_path — VARCHAR
- converted_file_path — VARCHAR
- category_id — INTEGER — Foreign key → DocumentCategory.id — NOT NULL
- template_id — INTEGER — Foreign key → DocumentTemplate.id — NOT NULL
- conversion_id — INTEGER — Foreign key → DocumentTemplate.conversion_id
DocumentCategory
- id — INTEGER — Primary key
- template_name (name) — VARCHAR — NOT NULL
- type — VARCHAR
- main_name — enum — NOT NULL — 대분류명 (정책자금, 시설공간, 인력교육, 판로마케팅, 기술RD)
- sub_name — enum — NOT NULL — 소분류명 (융자,보증,투자,입주공간,공용장비 등)
DocumentTemplate
- id — INTEGER — Primary key
- conversion_id — INTEGER — Foreign key → FileConversion.id — NOT NULL
- name — VARCHAR — NOT NULL
- type — VARCHAR
- start_date — DATE — NOT NULL — 템플릿이 생성된 시점을 넣습니다.
- template_code — VARCHAR — NOT NULL — 템플릿이 유저별로 생성된 것에 따른 임의의 숫자를 부여합니다. t_001, 002 .....
- file_path — VARCHAR — NOT NULL — 데모버전에서는 파일을 path의 형태로 받아서 관리합니다.
- field_name — VARCHAR — NOT NULL — 인풋이 hwp 일 경우에는 hwp를 pdf로 변환하고 메타데이터를 뽑아내면서 같이 추출합니다.
- field_type — VARCHAR — NOT NULL — 입력된 파일의 확장자를 입력합니다.
- required — BOOLEAN
- category_id — INTEGER — Foreign key → DocumentCategory.id — NOT NULL — 대분류, 소분류의 카테고리를 가집니다.
DocumentVersion
- id — INTEGER — Primary key
- document_id — INTEGER — Foreign key → Document.id — NOT NULL
- version_number — INTEGER
- created_at — TIMESTAMP
- creator_id — VARCHAR
- file_path — VARCHAR
Education
- id — INTEGER
- name — TEXT — NOT NULL
- type — TEXT
- start_date — DATE — NOT NULL
- end_date — DATE
- status — TEXT
Experience
- id — INTEGER
- name — TEXT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- occupation — TEXT
- desc — TEXT
- department — TEXT
FileConversion
- id — INTEGER — Primary key
- original_type — VARCHAR
- converted_type — VARCHAR
- original_path — VARCHAR
- converted_path — VARCHAR
- created_at — TIMESTAMP
Person
- id — INTEGER — Primary key
- name — TEXT — NOT NULL
- birth_date — DATE
- is_female — BOOLEAN
- title — TEXT
- occupation — TEXT
- phone_number — TEXT
- email — TEXT — NOT NULL
- password — NOT NULL
- address — TEXT — NOT NULL
- signature_path — TEXT
- identification_number — TEXT
- image_path — TEXT
Person_Experience
- id — INTEGER
- person_id — INTEGER — Foreign key → Person.id
- experience_id — INTEGER — Foreign key → Experience.id
- id (id2) — INTEGER — Foreign key → Person.id
ProcessHistory
- id — INTEGER — Primary key
- document_verson_id — INTEGER — Foreign key → DocumentVersion.id — NOT NULL
- document_id — INTEGER — Foreign key → DocumentVersion.document_id — NOT NULL
- process_type — VARCHAR
- status — VARCHAR
- created_at — TIMESTAMP
- creator_id — VARCHAR
- remarks — VARCHAR
User
- userId — Not Null — Primary key — NOT NULL
- email — Not Null
- password — Not Null
User_Education (Person_Education)
- id — INTEGER
- User_id (person_id) — INTEGER — Foreign key → Person.id
- education_id — INTEGER — Foreign key → Education.id