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