ㅅㄷㄴㅅ

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)