k-paas

Tables (34)

application_case

  • case_no — int — Primary key — NOT NULL
  • case_org_name — varchar(128)
  • case_year — varchar(10)
  • case_title — varchar(128)
  • case_content — longtext
  • use_yn — char(1) — Y or N
  • created — datetime
  • lastmodified — datetime
  • locale — varchar(10)
  • manager_name — varchar(60)
  • manager_belong — varchar(128)
  • manager_email — varchar(50)
  • manager_phone — varchar(25)
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • classification — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user

attachment_file

  • attachment_file_no — int — Primary key — NOT NULL
  • file_name — varchar(255)
  • file_path — varchar(512)
  • file_size — bigint
  • file_type — varchar(8)
  • created — varchar(20)
  • sha1sum — varchar(50)
  • md5sum — varchar(40)

banner

  • banner_no — int — Primary key — NOT NULL
  • title — varchar(128)
  • product — varchar(128)
  • use_yn — char(1) — Y or N
  • content — longtext
  • link — varchar(255)
  • attr_text — varchar(255)
  • manager_name — varchar(60)
  • manager_belong — varchar(128)
  • manager_phone — varchar(25)
  • manager_email — varchar(50)
  • created — datetime
  • lastmodified — datetime
  • locale — varchar(10)
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • file_no2 — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • file_no3 — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • classification — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user

board

  • board_no — int — Primary key — NOT NULL
  • title — varchar(128)
  • use_yn — char(1) — Y or N
  • content — longtext
  • answer — longtext
  • hits — int
  • created — datetime
  • lastmodified — datetime
  • locale — varchar(10)
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • board_classification — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • classification — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user

code_detail

  • key — v — Primary key — NOT NULL
  • value — varchar(128)
  • value_en — varchar(128)
  • description — varchar(255)
  • created — datetime
  • lastmodified — datetime
  • order — int
  • use_yn — char(1) — Y or N
  • group_id — v — Foreign key → code_group.id — NOT NULL — 부모테이블 : code_group

code_group

  • id — varchar(36) — Primary key — NOT NULL
  • name — varchar(128)
  • description — varchar(255)
  • use_yn — char(1) — Y or N
  • created — datetime
  • lastmodified — datetime

community

  • community_no — int — Primary key — NOT NULL
  • title — varchar(128)
  • content — longtext
  • created — datetime
  • lastmodified — datetime
  • like — int
  • locale — varchar(10)
  • hits — int
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • classification — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail

content

  • contant_no — int — Primary key — NOT NULL
  • use_page — varchar(128)
  • contnet — longtext
  • lastmodified — varchar(20)
  • locale — varchar(10)
  • page_name — varchar(128)

edu_apply

  • edu_apply_no — Int — Primary key — NOT NULL
  • work_field — varchar(128)
  • job_field — varchar(128)
  • total_career_period — varchar(50)
  • information_acquisition_path — varchar(128)
  • motivation_participation — varchar(128)
  • edu_content_no — int — Foreign key → edu_content.edu_content_no — NOT NULL — 부모 테이블 : edu_content
  • classification — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • created — datetime
  • edu_classification — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail

edu_content

  • edu_content_no — int — Primary key — NOT NULL
  • edu_title — varchar(128)
  • start_date — varchar(10)
  • end_date — varchar(10)
  • content — longtext
  • created — datetime
  • lastmodified — datetime
  • locale — v
  • deadline_yn — char(1) — Y or N
  • edu_classification — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • classification — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • session_classification — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • user_name — varchar(32)
  • apply_date — varchar(10)
  • survey_url — varchar(255)

edu_history

  • edu_history_no — int — Primary key — NOT NULL
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • edu_content_no — int — Foreign key → edu_content.edu_content_no — NOT NULL — 부모 테이블 : edu_content
  • file_no1 — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • file_no2 — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • classification — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • edu_classification — v — Foreign key → code_detail.key — NOT NULL — 부모테이블 : code_detail
  • created — datetime

event

  • event_no — int — Primary key — NOT NULL
  • title — varchar(128)
  • start_date — varchar(10)
  • end_date — varchar(10)
  • link_url — varchar(255)
  • content — longtext
  • created — datetime
  • lastmodified — datetime
  • locale — varchar(10)
  • use_yn — char(1) — Y or N
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • classification — v — Foreign key → code_detail.key — NOT NULL — 부모테이블 : code_detail
  • hits — int

hashtag

  • hashtag_no — int — Primary key — NOT NULL
  • hashtag_text — varchar(50)

heart_like

  • like_no — int — Primary key — NOT NULL
  • kpaas_project_no — int — Foreign key → kpaas_project.kpaas_project_no — NOT NULL
  • saas_project_no — int — Foreign key → saas_project.saas_project_no — NOT NULL
  • community_no — int — Foreign key → community.community_no — NOT NULL
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL

image

  • image_no — int — Primary key — NOT NULL
  • image_name — varchar(255)
  • created — datetime
  • lastmodified — datetime
  • classification — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • locale — varchar(10)

image_banner

  • image_banner_no — int — Primary key — NOT NULL
  • link_url — varchar(255)
  • title — varchar(128)
  • alt_text — varchar(255)
  • start_date — datetime
  • end_date — datetime
  • use_yn — char(1)
  • started — datetime
  • lastmodified — datetime
  • locale — varchar(10)
  • classification — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user

kpaas_project

  • kpaas_project_no — int — Primary key — NOT NULL
  • title — varchar(128)
  • content — longtext
  • use_yn — char(1) — Y or N
  • created — datetime
  • lastmodified — datetime
  • locale — varchar(10)
  • hits — int
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • classification — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • likes — int

landscape

  • landscape_no — int — Primary key — NOT NULL
  • company_name — varchar(128)
  • product — varchar(128)
  • link_url — varchar(255)
  • tag — varchar(255)
  • version — varchar(128)
  • description — varchar(255)
  • created — datetime
  • lastmodified — datetime
  • locale — varchar(10)
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • provided_company — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • license — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • classification1 — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • classification2 — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user

link_hashtag

  • link_hashtag_no — int — Primary key — NOT NULL
  • hashtag_no — int — Foreign key → hashtag.hashtag_no — NOT NULL — 부모 테이블 : hashtag
  • saas_project_no — int — Foreign key → saas_project.saas_project_no — NOT NULL — 부모 테이블 : saas_project
  • community_no — int — Foreign key → community.community_no — NOT NULL — 부모 테이블 : community
  • kpaas_project_no — int — Foreign key → kpaas_project.kpaas_project_no — NOT NULL — 부모 테이블 : kpaas_project
  • video_no — int — Foreign key → video.video_no — NOT NULL — 부모 테이블 : video

menu

  • menu_no — int — Primary key — NOT NULL
  • menu_name — varchar(50)
  • menu_uri — varchar(255)
  • blank_yn — char(1)
  • locale — varchar(10)
  • top_menu_no — int — Foreign key → top_menu.top_menu_no — NOT NULL

play_park

  • play_park_no — int — Primary key — NOT NULL
  • play_park_id — varchar(30)
  • created — datetime
  • expiration_date — datetime
  • job — varchar(50)
  • job_field — varchar(50)
  • total_career_period — varchar(50)
  • information_acquisition_path — varchar(128)
  • purpose_application — varchar(128)
  • language_be_used — varchar(30)
  • buildpack_be_used — varchar(30)
  • services_be_used — varchar(30)
  • necessity — varchar(128)
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • start_date — datetime
  • classfication — v — Foreign key → code_detail.key — NOT NULL — 부모테이블 : code_detail
  • st_classificatiom — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail

popup

  • popup_no — int — Primary key — NOT NULL
  • title — varchar(128)
  • link_url — varchar(255)
  • start_date — datetime
  • end_date — datetime
  • use_yn — char(1) — Y or N
  • width_position — int
  • heght_position — int
  • width_size — int
  • height_size — int
  • close_coords — varchar(20)
  • link_coords — varchar(20)
  • alt_text — varchar(255)
  • create_date — datetime
  • update_date — datetime
  • locale — varchar(10)
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user

qna

  • qna_no — int — Primary key — NOT NULL
  • title — varchar(128)
  • question — longtext
  • answer — longtext
  • hits — int
  • created — datetime
  • lastmodified — datetime
  • locale — varchar(10)
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • classification — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • user_id — varchar(128) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • status — v — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • old_user_id — varchar(128)
  • old_user_name — varchar(32)

release_package_file

  • release_package_file_no — int — Primary key — NOT NULL
  • title — varchar(128)
  • use_yn — char(1) — Y or N
  • version — varchar(12)
  • created — datetime
  • lastmodified — datetime
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • classification — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : code_detail
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • locale — varchar(10)
  • link — varchar(255)
  • md5sum — varchar(255)
  • sha1sum — varchar(255)
  • 유저명 — varchar(32)

reply

  • reply_no — int — Primary key — NOT NULL
  • parent_reply_no — int — 답글 기능에 필요
  • reply_content — varchar(1000) — 댓글 300자 제한
  • created — datetime
  • lastmodified — datetime
  • community_no — int — Foreign key → community.community_no — NOT NULL — 부모 테이블 : community
  • saas_project_no — int — Foreign key → saas_project.saas_project_no — 부모 테이블 : saas_project
  • kpaas_project_no — int — Foreign key → kpaas_project.kpaas_project_no — NOT NULL — 부모 테이블 : kpaas_project
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • admin_delete — varchar(2)

saas_project

  • saas_project_no — int — Primary key — NOT NULL
  • title — varchar(128)
  • institution — varchar(128)
  • content — longtext
  • manager_name — varchar(60)
  • manager_belong — varchar(128)
  • manager_phone — varchar(25)
  • manager_email — varchar(50)
  • use_yn — char(1) — Y or N
  • permission — varchar(10) — 허가 or 불허 or 대기중
  • created — datetime
  • lastmodified — datetime
  • locale — varchar(10) — 국문, 영문
  • hits — int
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • like — int

search_log

  • search_log_no — int — Primary key — NOT NULL
  • search_query — varchar(255)
  • search_date — datetime

spec_company

  • spec_company_no — int — Primary key — NOT NULL
  • spec_company_name — varchar(128)
  • use_yn — char(1) — Y or N
  • created — datetime
  • lastmodified — datetime
  • selection_date — varchar(20)
  • renewal_date — varchar(20)
  • expiration_date — varchar(20)
  • manager_name — varchar(60)
  • manager_belong — varchar(128)
  • manager_phone — varchar(25)
  • manager_email — varchar(50)
  • auth_status_yn — char(1) — Y or N
  • locale — varchar(10)
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL — 부모 테이블 : attachment_file
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user

spec_company_business

  • business_display_no — int — Primary key — NOT NULL
  • spec_company_no — int — Primary key — NOT NULL
  • business_name — varchar(255)
  • order_organ — varchar(128)
  • business_from_month — varchar(20)
  • bussiness_to_month — varchar(20)
  • use_yn — char(1) — Y or N
  • created — varchar(20)
  • lastmodified — varchar(20)

spec_company_certification_period

  • certification_period_no — int — Primary key — NOT NULL
  • business_display_no — int — Primary key — NOT NULL
  • selection_date — varchar(20)
  • expiration_date — varchar(20)
  • renewal_yn — char(1) — Y or N
  • created — varchar(20)
  • lastmodified — varchar(20)
  • auth_status — varchar(30)
  • value — int

stat_visit_page

  • visit_no — int — Primary key — NOT NULL
  • visit_page_uri — varchar(255)
  • visit_session — varchar(255)
  • visit_ip — varchar(128)
  • visit_date — datetime
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user

top_menu

  • top_menu_no — int — Primary key — NOT NULL
  • top_menu_name — varchar(50)
  • locale — varchar(10)

user

  • user_id — varchar(30) — Primary key — NOT NULL
  • password — varchar(30)
  • nickname — varchar(60)
  • user_name — varchar(60)
  • birthday — varchar(20)
  • belong — varchar(128)
  • tele_phone — varchar(25)
  • email — varchar(50)
  • login_cnt — int
  • lastmodified — datetime
  • lastlogin_time — datetime
  • created — datetime
  • agree_opt_yn — char(1) — Y or N
  • expert_completion_yn — char(1) — Y or N
  • instructor_completion_yn — char(1) — Y or N
  • classification — v — Foreign key → code_detail.key — NOT NULL
  • file_no — int — Foreign key → attachment_file.attachment_file_no — NOT NULL

video

  • video_no — int — Primary key — NOT NULL
  • video_link — varchar(255)
  • video_title — varchar(128)
  • video_created — datetime
  • use_yn — char(1) — Y or N
  • lastmodified — datetme
  • locale — varchar(10)
  • video_classification — varchar(36) — Foreign key → code_detail.key — NOT NULL — 부모 테이블 : attachment_file
  • user_id — varchar(30) — Foreign key → user.user_id — NOT NULL — 부모 테이블 : user
  • video_content — longtext