ㅅㄷㄴㅅ
Tables (34)
category_car_type
- seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_doc_type
- seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_email_value
- seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_event_option
- seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_member_company
- seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_member_department
- seed — int — NOT NULL
- position_index — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_member_objective
- seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_member_position
- seed — int — NOT NULL
- company_index — int
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_phone_value
- seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_schedule_type
- seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_share_branch
- seed — int — NOT NULL
- city_seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
category_share_type
- seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
cateogry_share_brach_city
- seed — int — NOT NULL
- index_num — int — NOT NULL
- index_name — varchar(50) — NOT NULL
sw_admin
- seed — int — NOT NULL
- admin_id — varchar(100)
- admin_pw — varchar(100)
- admin_name — varchar(50)
- admin_status — varchar(20)
- admin_super — int
- writeadminseed — int
- userip — varchar(50)
- insertdate — datetime
- admin_auth_temp — text
- admin_title — varchar(50)
- admin_rank — varchar(50)
sw_admin_auth
- seed — int — NOT NULL
- admin_seed — int — NOT NULL
- auth_index — int — NOT NULL
- category_name — varchar(20) — NOT NULL
sw_admin_auth_company
- seed — int — NOT NULL
- admin_seed — int — NOT NULL
- auth_index — int — NOT NULL
- company_index — int — NOT NULL
sw_admin_auth_coverage
- seed — int — NOT NULL
- admin_seed — int — NOT NULL
- category_auth — varchar(100)
- company_coverage — varchar(100) — NOT NULL
- position_coverage — varchar(100) — NOT NULL
sw_admin_auth_position
- seed — int — NOT NULL
- admin_seed — int — NOT NULL
- auth_index — int — NOT NULL
- position_index — int — NOT NULL
sw_doc_coverage
- seed — int — NOT NULL
- doc_seed — int — NOT NULL
- company_seed — int — NOT NULL
- position_seed — int — NOT NULL
- insertdate — datetime — NOT NULL
sw_doc_management
- seed — int — NOT NULL
- doc_type — int — NOT NULL
- doc_name — varchar(100)
- doc_thumb — varchar(100)
- doc_file — varchar(100)
- doc_status — varchar(5)
- insertadmin — int — NOT NULL
- insertdate — datetime — NOT NULL
sw_education
- seed — int — NOT NULL
- edu_title — varchar(150) — NOT NULL
- edu_content — text
- edu_type — varchar(10) — NOT NULL
- edu_training_com — int — NOT NULL
- edu_member_position — varchar(255)
- edu_addr1 — varchar(50)
- edu_addr2 — varchar(50)
- edu_datetime — datetime
- edu_studytime — int
- edu_recruitment_start — datetime
- edu_recruitment_end — datetime
- edu_exam_url — varchar(150)
- edu_status — varchar(255)
- edu_deadline — int
- insertdate — datetime
- insertadmin — datetime
sw_education_apply
- seed — int — NOT NULL
- education_seed — int — NOT NULL
- member_seed — int — NOT NULL
- apply_status — varchar(10) — NOT NULL
- insertdate — datetime — NOT NULL
sw_education_coverage
- seed — int — NOT NULL
- education_seed — int — NOT NULL
- position_seed — varchar(255)
sw_event_option
- seed — int — NOT NULL
- option_type — int — NOT NULL
- category_index — int — NOT NULL
- option_name — varchar(100) — NOT NULL
- insertdate — datetime — NOT NULL
- insertadmin — int — NOT NULL
sw_member
- seed — int — NOT NULL
- member_id — varchar(50) — NOT NULL
- password — varchar(200) — NOT NULL
- position_index — int
- company_index — int
- department_index — int
- name — varchar(100) — NOT NULL
- birthday — date
- phone1 — int
- phone2 — int
- phone3 — int
- email1 — varchar(150)
- email2 — varchar(150)
- email2_sel — int
- auto_login — varchar(10)
- system_alert — varchar(10)
- push_alert — varchar(10)
- alert_token — varchar(300)
- login_totken — varchar(300)
- objective — int
- objective_txt — varchar(200)
- objective_start_date — date
- objective_end_date — date
- objective_num — int
- work_start_time — time(7)
- work_end_time — time(7)
- work_day — varchar(50)
- signup_time — datetime — NOT NULL
- member_last_login — datetime
sw_member_alert
- seed — Primary key — NOT NULL
- alert_type
- alert_title
- alert_link
- alert_show
- insertdate
sw_member_education
- seed — int — NOT NULL
- mem_seed — int — NOT NULL
- edu_seed — int — NOT NULL
- attendance — varchar(10) — NOT NULL
- insertdate — datetime — NOT NULL
sw_member_schedule
- seed — int — NOT NULL
- member_seed — int — NOT NULL
- schedule_date — date — NOT NULL
- schedule_time — time(7)
- schedule_type — int
- memo — varchar(300) — NOT NULL
- address1 — varchar(200)
- address2 — varchar(200)
- service_time — int
- service_km — int
- start_place — varchar(100)
- end_place — varchar(100)
- insertdate — datetime — NOT NULL
sw_member_share
- seed — int — NOT NULL
- member_seed — int — NOT NULL
- share_type — int
- city — int
- branch — int
- share_seed — int
- insertdate — datetime — NOT NULL
sw_notice
- seed — int — NOT NULL
- notice_title — varchar(100) — NOT NULL
- notice_content — text — NOT NULL
- notice_type — int — NOT NULL
- notice_status — varchar(10)
- viewcnt — int — NOT NULL
- insertadmin — int — NOT NULL
- insertdate — datetime — NOT NULL
sw_popup
- seed — int — NOT NULL
- popup_title — varchar(100) — NOT NULL
- popup_img — varchar(200) — NOT NULL
- popup_link — varchar(100)
- popup_status — varchar(10) — NOT NULL
- insertadmin — int
- insertdate — datetime
- popup_sort — int
sw_popup_coverage
- seed — int — NOT NULL
- popup_seed — int — NOT NULL
- company_seed — int
- position_seed — int
- insertdate — datetime — NOT NULL
멤버 공유 (sm_member_share)
- seed — Primary key — NOT NULL
- 멤버seed (member_seed)
- 공유타입 (target_type)
- 공유seed (target_seed)
- 등록일 (insertdate)
멤버 차량운행 공유 (sw_vehicle_event_share)
- seed — Primary key — NOT NULL
- write_member_seed
- 공유타입 (target_type)
- 공유seed (target_seed)
- 등록일 (insertdate)