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": 일반권한