betterflow

Tables (39)

Authority

  • author_id — NUMBER — Primary key — NOT NULL — 권한번호;
  • author_name — VARCHAR2(60) — NOT NULL
  • author_create_date — DATE — NOT NULL
  • author_appr_date — DATE

AwardRecord

  • award_id — NUMBER — Primary key — NOT NULL — 수상
  • award_name — VARCHAR2(60) — NOT NULL
  • issue_agency — VARCHAR2(60) — NOT NULL
  • award_day — DATE — NOT NULL
  • explain — VARCHAR2(150)
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

BOARDDEVIDE

  • BOARD_DEVIDE_ID — NUMBER — Primary key — NOT NULL — 게시판
  • BOARD_DEVIDE_NAME — VARCHAR2(150)
  • BOARD_DELETE_YN — CHAR(1)

Board

  • board_id — NUMBER — Primary key — NOT NULL — 게시판
  • board_title — VARCHAR2(50) — NOT NULL
  • board_create_date — DATE — NOT NULL
  • board_content — CLOB — NOT NULL
  • board_hits — NUMBER — NOT NULL
  • board_status — CHAR(1) — NOT NULL
  • board_devide — VARCHAR2(15) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

BoardAttach

  • bf_id — NUMBER — Primary key — NOT NULL — 게시판
  • bf_origin_name — VARCHAR2(50) — NOT NULL
  • bf_alter_name — VARCHAR2(50) — NOT NULL
  • bf_path — VARCHAR2(300) — NOT NULL
  • board_id — NUMBER — Foreign key → Board.board_id

Career

  • career_id — NUMBER — Primary key — NOT NULL — 경력
  • company_name — VARCHAR2(60) — NOT NULL
  • job_position — VARCHAR2(60) — NOT NULL
  • work_period — VARCHAR2(30) — NOT NULL
  • explain — VARCHAR2(150) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

CertIssueRecord

  • cert_issue_id — NUMBER — Primary key — NOT NULL — 증명서
  • cert_title — VARCHAR2(50) — NOT NULL
  • cert_request_date — DATE — NOT NULL
  • cert_appr_date — DATE
  • cert_id — NUMBER — Foreign key → Certificate.cert_id — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL
  • cert_request_reason — VARCHAR2(300) — NOT NULL

CertficateInfo

  • certInfo_id — NUMBER — Primary key — NOT NULL — 자격증
  • cert_name — VARCHAR2(60) — NOT NULL
  • auth_agency — VARCHAR2(60) — NOT NULL
  • license_number — VARCHAR2(60) — NOT NULL
  • expire_date — DATE — NOT NULL
  • license_url — VARCHAR2(300) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

Certificate

  • cert_id — NUMBER — Primary key — NOT NULL — 증명서
  • cert_title — VARCHAR2(60) — NOT NULL
  • cert_regist_date — DATE — NOT NULL
  • cert_explain — VARCHAR2(150) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

Chat

  • chat_id — NUMBER — Primary key — NOT NULL — 채팅방
  • chat_name — VARCHAR2(300) — NOT NULL

ChatMember

  • chat_member_id — NUMBER — Primary key — NOT NULL — 채팅방
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL
  • chat_id — NUMBER — Foreign key → Chat.chat_id — NOT NULL

Comm

  • comm_id — NUMBER — Primary key — NOT NULL — 댓글
  • comm_content — VARCHAR2(300) — NOT NULL
  • comm_create_time — DATE — NOT NULL
  • board_id — NUMBER — Foreign key → Board.board_id — NOT NULL

Commute

  • commute_code — NUMBER — Primary key — NOT NULL — 출퇴근
  • commute_in_time — DATE
  • commute_out_time — DATE
  • commute_status — VARCHAR2(30) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

CompanyInfo

  • cp_id — NUMBER — Primary key — NOT NULL — 회사
  • cp_name — VARCHAR2(60) — NOT NULL
  • cp_address — VARCHAR2(120) — NOT NULL
  • cp_phone — VARCHAR2(20) — NOT NULL
  • cp_ceo — VARCHAR2(50) — NOT NULL
  • cp_introduce — VARCHAR2(600)
  • cp_establish — DATE — NOT NULL
  • cp_slogan — VARCHAR2(200)

Dept

  • dept_id — NUMBER — Primary key — NOT NULL — 부서코드;
  • dept_name — VARCHAR2(50) — NOT NULL

DocuCategory

  • docu_cate_id — NUMBER — Primary key — NOT NULL — 문서
  • docu_cate_name — VARCHAR2(60) — NOT NULL

DraftAttach

  • draft_file_id — NUMBER — Primary key — NOT NULL — 기안
  • draft_file_origin_name — VARCHAR2(50) — NOT NULL
  • draft_file_alter_name — VARCHAR2(50) — NOT NULL
  • draft_file_path — VARCHAR2(300) — NOT NULL
  • draft_file_separate — VARCHAR2(10) — NOT NULL
  • draft_rec_no — NUMBER — Foreign key → DraftRecord.draft_rec_no — NOT NULL

DraftFile

  • draft_no — NUMBER — Primary key — NOT NULL — 기안서
  • draft_title — VARCHAR2(60) — NOT NULL
  • draft_initial_regist_date — DATE — NOT NULL
  • draft_modify_date — DATE
  • draft_explain — VARCHAR2(150) — NOT NULL
  • user_write_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL
  • user_update_id_ — NUMBER — Foreign key → UserClient.user_id — NOT NULL
  • docu_cate_id — NUMBER — Foreign key → DocuCategory.docu_cate_id — NOT NULL
  • draft_content — CLOB — NOT NULL
  • draft_url — VARCHAR2(300)

DraftListRecord

  • draft_history_id — NUMBER — Primary key — NOT NULL — 기안서
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL
  • draft_pay_date — DATE — NOT NULL
  • draft_rec_no — NUMBER — Foreign key → DraftRecord.draft_rec_no — NOT NULL

DraftRecord

  • draft_rec_no — NUMBER — Primary key — NOT NULL — 기안서
  • draft_rec_title — VARCHAR2(50) — NOT NULL
  • draft_rec_regist_date — DATE — NOT NULL
  • draft_rec_final_appr — DATE
  • draft_rec_status — VARCHAR2(10) — NOT NULL

DraftRelated

  • draft_related_person_id — NUMBER — Primary key — NOT NULL — 기안서
  • draft_separate — VARCHAR2(10) — NOT NULL
  • draft_rec_no — NUMBER — Foreign key → DraftRecord.draft_rec_no — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

DraftTitleRule

  • docu_title_rule_id — NUMBER — Primary key — NOT NULL — 문서
  • docu_title_rule_name — VARCHAR2(300) — NOT NULL

DraftTitleRuleRecord

  • docu_title_rule_his_id — NUMBER — Primary key — NOT NULL — 제목
  • docu_title_rule_order — VARCHAR2(300) — NOT NULL
  • docu_title_rule_id — NUMBER — Foreign key → DraftTitleRule.docu_title_rule_id — NOT NULL
  • draft_rec_no — NUMBER — Foreign key → DraftRecord.draft_rec_no — NOT NULL

EduRecord

  • edu_record_id — NUMBER — Primary key — NOT NULL — 교육
  • edu_curriculum — VARCHAR2(60) — NOT NULL
  • edu_complete_status — VARCHAR2(60) — NOT NULL
  • edu_period — VARCHAR2(30) — NOT NULL
  • edu_place — VARCHAR2(60) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

Education

  • edu_id — NUMBER — Primary key — NOT NULL — 학력정보
  • school_name — VARCHAR2(60) — NOT NULL
  • is_enroll — CHAR(1) — NOT NULL
  • enroll_period — VARCHAR2(30) — NOT NULL
  • major — VARCHAR2(60) — NOT NULL
  • score — NUMBER(5,4) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

EmployType

  • emp_type_id — NUMBER — Primary key — NOT NULL — 고용
  • emp_type_name — VARCHAR2(60) — NOT NULL

FavoriteDocu

  • favor_docu_id — NUMBER — NOT NULL
  • user_id — NUMBER — NOT NULL
  • draft_no — NUMBER — NOT NULL

Job

  • job_id — NUMBER — Primary key — NOT NULL — 직위
  • job_name — VARCHAR2(60) — NOT NULL

Label

  • label_id — NUMBER — Primary key — NOT NULL — 라벨
  • label_name — VARCHAR2(100) — NOT NULL
  • label_color — VARCHAR2(30) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL
  • draft_rec_no — NUMBER — Foreign key → DraftRecord.draft_rec_no — NOT NULL

PatentInfo

  • patent_id — NUMBER — Primary key — NOT NULL — 특허
  • patent_name — VARCHAR2(60) — NOT NULL
  • patent_office — VARCHAR2(60) — NOT NULL
  • patent_status — VARCHAR2(60) — NOT NULL
  • patent_inventor — VARCHAR2(50) — NOT NULL
  • patent_url — VARCHAR2(300) — NOT NULL
  • patent_explain — VARCHAR2(150) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

Process

  • p_id — NUMBER — Primary key — NOT NULL — 프로세스
  • p_name — VARCHAR2(30) — NOT NULL
  • p_explain — VARCHAR2(150)
  • p_modify_date — DATE
  • p_type — VARCHAR2(30) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

ProcessDetail

  • pd_id — NUMBER — Primary key — NOT NULL — 프로세스
  • appr_type — CHAR(9) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL
  • p_id — NUMBER — NOT NULL
  • draft_rec_no — NUMBER — Foreign key → DraftRecord.draft_rec_no — NOT NULL

ProjectInfo

  • proj_info_id — NUMBER — Primary key — NOT NULL — 프로젝트
  • proj_info — VARCHAR2(100) — NOT NULL
  • place_conduct — VARCHAR2(60) — NOT NULL
  • proj_period — VARCHAR2(30) — NOT NULL
  • explain — VARCHAR2(150)
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

Schedule

  • schedule_id — NUMBER — Primary key — NOT NULL — 일정
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL
  • sche_mg_info_id — NUMBER — Foreign key → ScheduleManage.sche_mg_info_id — NOT NULL

ScheduleManage

  • sche_mg_info_id — NUMBER — Primary key — NOT NULL — 일정관리
  • start_time — DATE — NOT NULL
  • end_time — DATE — NOT NULL
  • title — VARCHAR2(60) — NOT NULL
  • location — VARCHAR2(60) — NOT NULL
  • content — VARCHAR2(300) — NOT NULL
  • user_id — NUMBER — Foreign key → UserClient.user_id — NOT NULL

UserClient

  • user_id — NUMBER — Primary key — NOT NULL — 사용자
  • user_name — VARCHAR2(50) — NOT NULL
  • user_intro — NVARCHAR2(1500)
  • user_skill — VARCHAR2(1500)
  • user_detail — VARCHAR2(1500)
  • user_phone — VARCHAR2(20)
  • user_telphone — VARCHAR2(20) — NOT NULL
  • user_address — VARCHAR2(300) — NOT NULL
  • user_birth — VARCHAR2(20) — NOT NULL
  • user_gender — CHAR(3) — NOT NULL
  • user_marry — CHAR(3) — NOT NULL
  • user_status — VARCHAR2(30) — NOT NULL
  • user_join_date — DATE — NOT NULL
  • user_detail_job — VARCHAR2(300)
  • user_job — VARCHAR2(300) — NOT NULL
  • dept_id — NUMBER — Foreign key → Dept.dept_id — NOT NULL
  • author_id — NUMBER — Foreign key → Authority.author_id — NOT NULL
  • emp_type_id — NUMBER — Foreign key → EmployType.emp_type_id — NOT NULL
  • job_id — NUMBER — Foreign key → Job.job_id — NOT NULL
  • cp_id — NUMBER — Foreign key → CompanyInfo.cp_id — NOT NULL
  • user_pw — VARCHAR2(30) — NOT NULL
  • user_email — VARCHAR2(30) — NOT NULL

VacationInfo

  • vaca_info_id — NUMBER — Primary key — NOT NULL — 휴가
  • vaca_reason — VARCHAR2(300)
  • vaca_period — VARCHAR2(30)
  • vaca_appr_reason — VARCHAR2(300)
  • vaca_usage_day — NUMBER
  • vaca_appr_day — NUMBER
  • vaca_kind_id — NUMBER — Foreign key → VacationType.vaca_kind_id — NOT NULL
  • vaca_sort_id — NUMBER — Foreign key → VacationKind.vaca_sort_id — NOT NULL

VacationKind

  • vaca_sort_id — NUMBER — Primary key — NOT NULL — 휴가
  • vaca_sort_content — VARCHAR2(60) — NOT NULL

VacationType

  • vaca_kind_id — NUMBER — Primary key — NOT NULL — 휴가
  • vaca_kind_name — VARCHAR2(60) — NOT NULL