SOO_ERP
soo erp
Tables (28)
activity
- id — bigint(20) — Primary key — NOT NULL
- article_id — bigint(20) — Foreign key → article.id — NOT NULL
- content_id — bigint(20) — Foreign key → content.id — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — NOT NULL
- last_updated — datetime — NOT NULL
- point — int(11) — NOT NULL
- point_type — varchar(255) — NOT NULL
- type — varchar(255) — NOT NULL
anonymous
- id — bigint(20) — Primary key — NOT NULL
- article_id — bigint(20) — Foreign key → article.id — NOT NULL
- content_id — bigint(20) — Foreign key → content.id — NOT NULL
- version — bigint(20) — NOT NULL
- type — varchar(255) — NOT NULL
area_city_code
- id — varchar(255) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- name — varchar(255) — NOT NULL
area_district_code
- id — varchar(255) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- area_city_code_id — varchar(255) — Foreign key → area_city_code.id — NOT NULL
- name — varchar(255) — NOT NULL
article
- id — bigint(20) — Primary key — NOT NULL
- category_id — varchar(255) — Foreign key → category.code — NOT NULL
- version — bigint(20) — NOT NULL
- a_nick_name — varchar(255)
- anonymity — bit(1) — NOT NULL
- choice — bit(1) — NOT NULL
- content_id — bigint(20) — Foreign key → content.id
- create_ip — varchar(255)
- date_created — datetime — NOT NULL
- enabled — bit(1) — NOT NULL
- is_recruit — bit(1) — NOT NULL
- last_updated — datetime — NOT NULL
- note_count — int(11) — NOT NULL
- scrap_count — int(11) — NOT NULL
- selected_note_id — bigint(20) — Foreign key → content.id
- tag_string — varchar(255)
- title — varchar(255) — NOT NULL
- view_count — int(11) — NOT NULL
- vote_count — int(11) — NOT NULL
article_tag
- article_tags_id — bigint(20) — Foreign key → article.id
- tag_id — bigint(20) — Foreign key → tag.id
banner
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — NOT NULL
- image — varchar(255)
- last_updated — datetime — NOT NULL
- name — varchar(255) — NOT NULL
- target — varchar(255)
- type — varchar(255) — NOT NULL
- url — varchar(255) — NOT NULL
- visible — bit(1) — NOT NULL
banner_click
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- banner_id — bigint(20) — Foreign key → banner.id — NOT NULL
- click_count — int(11) — NOT NULL
- date_created — datetime — NOT NULL
- ip — varchar(255) — NOT NULL
career
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
category
- code — varchar(255) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- anonymity — bit(1)
- date_created — datetime — NOT NULL
- default_label — varchar(255) — NOT NULL
- enabled — bit(1) — NOT NULL
- external_link — varchar(255)
- icon_css_names — varchar(255)
- isurl — bit(1) — NOT NULL
- label_code — varchar(255) — NOT NULL
- last_updated — datetime — NOT NULL
- level — int(11) — NOT NULL
- parent_id — varchar(255) — Foreign key → category.code
- require_tag — bit(1) — NOT NULL
- sort_order — int(11) — NOT NULL
- url — varchar(255)
- use_evaluate — bit(1) — NOT NULL
- use_note — bit(1) — NOT NULL
- use_opinion — bit(1) — NOT NULL
- use_tag — bit(1) — NOT NULL
- writable — bit(1) — NOT NULL
- write_by_external_link — bit(1)
change_log
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- article_id — bigint(20) — Foreign key → article.id — NOT NULL
- content_id — bigint(20) — Foreign key → content.id
- date_created — datetime — NOT NULL
- md5 — varchar(255) — NOT NULL
- patch — longtext — NOT NULL
- revision — int(11) — NOT NULL
- type — varchar(255) — NOT NULL
company_info
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- description — longtext
- email — varchar(255) — NOT NULL
- employee_number — int(11) — NOT NULL
- homepage_url — varchar(255)
- tel — varchar(255) — NOT NULL
- welfare — longtext
content
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- a_nick_name — varchar(255)
- anonymity — bit(1) — NOT NULL
- article_id — bigint(20) — Foreign key → article.id
- create_ip — varchar(255)
- date_created — datetime — NOT NULL
- last_updated — datetime — NOT NULL
- selected — bit(1) — NOT NULL
- text — longtext — NOT NULL
- text_type — int(11) — NOT NULL
- type — int(11) — NOT NULL
- vote_count — int(11) — NOT NULL
content_file
- content_files_id — bigint(20) — Foreign key → content.id
- file_id — bigint(20) — Foreign key → file.id
content_vote
- id — bigint(20) — Primary key — NOT NULL
- article_id — bigint(20) — Foreign key → article.id — NOT NULL
- content_id — bigint(20) — Foreign key → content.id — NOT NULL
- date_created — datetime — NOT NULL
- point — int(11) — NOT NULL
file
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- attach_type — varchar(255) — NOT NULL
- byte_size — int(11) — NOT NULL
- height — int(11) — NOT NULL
- name — varchar(255) — NOT NULL
- org_name — varchar(255) — NOT NULL
- type — varchar(255) — NOT NULL
- width — int(11) — NOT NULL
follow
- date_created — datetime — NOT NULL
job_position
- id — bigint(20) — Primary key — NOT NULL
- recruit_id — bigint(20) — Foreign key → recruit.id — NOT NULL
- version — bigint(20) — NOT NULL
- description — varchar(255) — NOT NULL
- job_pay_type — varchar(255) — NOT NULL
- max_career — int(11)
- min_career — int(11) — NOT NULL
- tag_string — varchar(255)
- title — varchar(255) — NOT NULL
job_position_tag
- job_position_tags_id — bigint(20) — Foreign key → job_position.id
- tag_id — bigint(20) — Foreign key → tag.id
notification
- id — bigint(20) — Primary key — NOT NULL
- article_id — bigint(20) — Foreign key → article.id — NOT NULL
- content_id — bigint(20) — Foreign key → content.id — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — NOT NULL
- last_updated — datetime — NOT NULL
- type — varchar(255) — NOT NULL
notification_read
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- last_read — datetime — NOT NULL
opinion
- id — bigint(20) — Primary key — NOT NULL
- content_id — bigint(20) — Foreign key → content.id — NOT NULL
- version — bigint(20) — NOT NULL
- comment — longtext — NOT NULL
- date_created — datetime — NOT NULL
- last_updated — datetime — NOT NULL
- vote_count — int(11) — NOT NULL
recruit
- id — bigint(20) — Primary key — NOT NULL
- article_id — bigint(20) — Foreign key → article.id — NOT NULL
- version — bigint(20) — NOT NULL
- city — varchar(255) — NOT NULL
- closed — bit(1) — NOT NULL
- district — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- job_type — varchar(255) — NOT NULL
- start_date — varchar(255)
- tel — varchar(255) — NOT NULL
- working_month — int(11)
scrap
- article_id — bigint(20) — Foreign key → article.id — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — NOT NULL
spam_word
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- text — varchar(255) — NOT NULL
tag
- id — bigint(20) — Primary key — NOT NULL
- date_created — datetime — NOT NULL
- description — varchar(255)
- name — varchar(255) — NOT NULL
- tagged_count — int(11) — NOT NULL
tag_similar_text
- id — bigint(20) — Primary key — NOT NULL
- tag_id — bigint(20) — Foreign key → tag.id — NOT NULL
- version — bigint(20) — NOT NULL
- text — varchar(255) — NOT NULL
user
- COMPANY_ID — number(20) — Primary key — NOT NULL — 회원 시퀀스 (자동부여) 가입날짜 + 시퀀스 (0000)
- USER_NAME — varchar(200) — NOT NULL — 회원 이름
- PASS_WORD — varchar(1000) — NOT NULL — 비밀번호 hash값
- USER_TEL1 — number(20) — 회원 전화번호
- USER_TEL2 — number(20) — 전화번호 2
- USER_EMAIL — varchar(1000) — 회원 이메일주소
- USER_BRDT — DATE — 생년월일 yyyymmdd
- USER_ADDR — varchar(2000) — 회원 주소(거주지)
- USER_GRAD — varchar(2) — NOT NULL — 회원상태 00:회장 01:대표이사 02:사장 10:팀장 20:부장 30:차장 40:과장 50:대리 60:주임 70:사원 80:프리랜서
- USE_YN — varchar(10) — NOT NULL — 회원상태 00:투입중 10:대기중 20:휴가 30:병가 99:퇴사
- JOIN_DATE — DATE — 입사년월 yyyymmdd HH:MM:SS
- UPDT_DATE — DATE — USE_YN 업데이트 날짜 yyyymmdd HH:MM:SS
- PRMT_DATE — DATE — 승진날짜(USER_GRAD 업데이트날짜) yyyymmdd HH:MM:SS
- UPDT_IP — DATE — 마지막 업데이트 날짜 yyyymmdd HH:MM:SS
- ADMN_YN — varcher(2) — NOT NULL — 관리자여부 "Y" : 관리자 권한 "N": 일반권한