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