기숙사 관리시스템
테이블 (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