기숙사 관리시스템

테이블 (22)

building_info

  • buil_seq — 기본 키 — NOT NULL
  • buil_floor
  • buil_bun
  • buil_tsum
  • buil_tasum
  • buil_num
  • buil_country
  • buil_human
  • buil_img
  • buil_troom
  • buil_date
  • buil_eddate
  • buil_edip

director_info

  • dir_seq — 기본 키 — NOT NULL
  • dir_name
  • dir_id
  • dir_pass
  • dir_join_date
  • dir_leave_date
  • dir_work_time_s
  • dir_work_time_e
  • dir_check
  • dir_level
  • au_id
  • au_ip
  • dir_ip
  • dir_tell
  • dir_number
  • dir_ymd
  • dir_home_tel
  • dir_sex
  • dir_post
  • dir_addr1
  • dir_addr2
  • dir_etc
  • dir_ed_ip
  • dir_ed_date
  • dir_indate
  • dir_email1
  • dir_email2

dt_lvs

  • dir_seq — 외래 키 → director_info.dir_seq — NOT NULL
  • dtv_seq
  • dtv_gu
  • dtv_level_tx
  • dtv_level
  • dtv_dsbd_1
  • dtv_dsbd_2
  • dtv_rm_1
  • dtv_rm_2
  • dtv_rm_3
  • dtv_st_1
  • dtv_st_2
  • dtv_st_3
  • dtv_st_4
  • dtv_st_5
  • dtv_st_6
  • dtv_mg_1
  • dtv_mg_2
  • dtv_inseq
  • dtv_in_uid
  • dtv_inip
  • dtv_indate
  • dtv_ed_seq
  • dtv_edip
  • dtv_ed_uid
  • dtv_ed_date

dt_schedule

  • dts_seq
  • dts_uid
  • dts_uname
  • dts_uhp
  • dts_dirseq
  • dts_daytime
  • dts_weektime
  • dts_mon
  • dts_tue
  • dts_wed
  • dts_thu
  • dts_fri
  • dts_sat
  • dts_sun
  • dts_allday
  • dts_part
  • dts_repeat
  • dts_stime
  • dts_stime2
  • dts_etime
  • dts_etime2
  • dts_sdate
  • dts_edate
  • dts_buil_name
  • dts_buil_seq
  • dts_buil_floor
  • dts_repeat_stime
  • dts_repeat_etime
  • dts_workdate
  • dts_inadm
  • dts_inip
  • dts_indate

dt_wk_schedule_ed

  • dts_wk_seq
  • dts_wk_uid
  • dts_wk_uname
  • dt_seq_wk
  • dts_wk_date1
  • dts_wk_date2
  • dts_wk_edate1
  • dts_wk_edate2
  • dts_wk_gu
  • dts_wk_etc1
  • dts_wk_etc2
  • dts_wk_stime1
  • dts_wk_stime2
  • dts_wk_etime1
  • dts_wk_etime2
  • dts_wk_allday

out_overnight_ori

  • st_buil_name — 외래 키 → st_info.st_buil_name — NOT NULL
  • out_seq
  • out_st_id
  • out_st_name
  • out_step1
  • out_step2
  • out_buil_seq
  • out_buil_name
  • out_buil_floor
  • out_buil_room
  • outing_ch
  • out_date
  • out_s
  • out_e
  • out_state
  • overnight_ch
  • over_date
  • orver_s
  • orver_e
  • over_state
  • out_dir_name
  • out_dir_ip
  • out_over_date
  • out_over_st
  • out_over_s
  • out_over_e
  • out_over_night_ch

over_night

  • st_buil_name — 외래 키 → st_info.st_buil_name — NOT NULL
  • out_seq
  • out_st_id
  • out_st_name
  • out_step1
  • out_step2
  • out_buil_seq
  • out_buil_name
  • out_buil_floor
  • out_buil_room
  • outing_ch
  • out_date
  • out_s
  • out_e
  • out_state
  • out_dir_name
  • out_dir_ip

rcu_ch_icon

  • icon_seq — 기본 키
  • rcu_int
  • rcu_1_ic_on
  • rcu_2_ic_on
  • rcu_3_ic_on
  • rcu_4_ic_on
  • rcu_5_ic_on
  • rcu_6_ic_on
  • rcu_7_ic_on
  • rcu_8_ic_on
  • rcu_1_ic_off
  • rcu_2_ic_off
  • rcu_3_ic_off
  • rcu_4_ic_off
  • rcu_5_ic_off
  • rcu_6_ic_off
  • rcu_7_ic_off
  • rcu_8_ic_off

rcu_ch_info

  • rcu_seq — 기본 키
  • icon_seq — 외래 키 → rcu_ch_icon.icon_seq
  • rcu_name
  • rcu_use
  • rcu_buil_name
  • rcu_buil_seq
  • rcu_rm_floor
  • rcu_rm_num
  • rcu_1
  • rcu_2
  • rcu_3
  • rcu_4
  • rcu_inat
  • rcu_outat
  • rcu_client_id
  • rcu_client_ip

re_de_point

  • re_seq
  • re_st_name
  • tot_reward
  • tot_demerit
  • reward
  • demerit
  • re_de_date
  • re_dir_ip
  • re_dir_id

right_control

  • rct_seq — 기본 키
  • rct_rtime1
  • rct_rtime2
  • rct_rtime3
  • rct_otime1
  • rct_otime2
  • rct_otime3
  • rct_mtime1
  • rct_mtime2
  • rct_mtime3
  • rct_ntime1
  • rct_ntime2
  • rct_ntime3
  • rct_edt_date
  • rct_edt_ip
  • rct_status

room_etc

  • re_idx — 기본 키 — NOT NULL
  • re_txt
  • re_indate
  • re_inidx
  • re_inip
  • re_eddate
  • re_edidx
  • re_edip

room_info

  • re_idx — 외래 키 → room_etc.re_idx — NOT NULL
  • rm_seq
  • rm_num
  • rm_floor
  • rm_bun_idx
  • rm_bun
  • rm_buil_name
  • rm_buil_bun
  • rcu_ip
  • rcu_name
  • rcu_eq
  • pers_num
  • rm_use_check
  • rm_use_num
  • rm_use_count
  • rm_use_info
  • rm_rcu_ch
  • rm_auto
  • rm_etc

room_od_etc

  • rot_idx — 기본 키
  • rcu_seq — 외래 키 → rcu_ch_info.rcu_seq
  • icon_seq — 외래 키 → rcu_ch_info.icon_seq
  • rct_seq — 외래 키 → right_control.rct_seq
  • rot_building_idx
  • rot_building_txt
  • rot_floor
  • rot_room_t
  • rot_room_num
  • rot_room_user_t
  • rot_indate
  • rot_inidx
  • rot_inip
  • rot_eddate
  • rot_edidx
  • rot_edip
  • Field12

room_use

  • st_buil_name — 외래 키 → st_info.st_buil_name — NOT NULL
  • use_seq
  • use_st_id
  • use_st_name
  • use_step1
  • use_step2
  • use_rm_num
  • use_buil_name
  • use_buil_seq
  • use_buil_floor
  • use_date_s
  • use_date_e
  • use_sdate_s
  • use_sdate_in
  • use_pgu
  • use_pay
  • use_pay_ch
  • use_pay_mn
  • use_pay_mn_tx
  • use_dir_name
  • use_dir_ip
  • use_info

s_line

  • l_seq
  • l_line1
  • l_line_txt

s_line_2

  • i_seq
  • i_l_line1
  • i_line2
  • i_line2_txt

sit_m

  • sit_m_seq
  • sit_m_mn
  • sit_m_num
  • sit_m_text
  • sit_m_icon
  • sit_m_show1
  • sit_m_show2
  • sit_m_url
  • sit_m_ineq
  • sit_m_gu
  • sit_m_indt
  • sit_m_inip
  • sit_m_egu
  • sit_m_edeq
  • sit_m_edip
  • sit_m_eddt

sit_set

  • sit_seq
  • sit_stgu
  • sit_fvcon
  • sit_titnm
  • sit_logo

st_info

  • st_buil_name — 기본 키 — NOT NULL
  • st_id
  • st_dep1
  • st_dep2
  • st_name
  • st_sex
  • st_hp
  • st_home_ph
  • st_ymd
  • st_for
  • st_buil_seq
  • st_rm_num
  • st_rm_floor
  • st_work_time_s
  • st_work_time_e
  • st_room_s
  • st_room_e
  • st_check
  • st_state
  • st_post
  • st_addr1
  • st_addr2
  • st_addr_etc
  • st_fm
  • st_cardno
  • st_relssuecnt
  • st_csex
  • st_department
  • st_roomno
  • st_personuser4
  • st_personuser5

st_info_dlt

  • st_seq — 기본 키 — NOT NULL
  • st_id
  • st_dep1
  • st_dep2
  • st_name
  • st_sex
  • st_hp
  • st_home_ph
  • st_ymd
  • st_for
  • st_buil_name
  • st_buil_seq
  • st_rm_num
  • st_rm_floor
  • st_work_time_s
  • st_work_time_e
  • st_room_s
  • st_room_e
  • st_check
  • st_state
  • st_post
  • st_addr1
  • st_addr2
  • st_addr_etc
  • st_fm
  • st_cardno
  • st_relssuecnt
  • st_csex
  • st_department
  • st_roomno
  • st_personuser4
  • st_personuser5
  • st_indate

sys_au

  • au_seq
  • au_id
  • au_pass
  • au_ip
  • au_time_s
  • au_lv
  • au_level
  • au_name
  • au_hp
  • au_home_tell
  • au_sex
  • au_ymd
  • au_post
  • au_addr1
  • au_addr2
  • au_etc
  • au_sabun
  • au_mail1
  • au_email2
  • au_indate