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