PHI
gnuboard5 erd
Tables (22)
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of g5_content (im_bbs_notice)
- idx — int — Primary key — NOT NULL
- bo_parent — int
- bo_depth (bo_deptht) — int
- bo_category — varchar(255)
- bo_notice — enum('Y','N')
- bo_depart — varchar(255)
- bo_secert — enum('Y','N')
- bo_sdate — date
- bo_edate — date
- bo_target_depart — varchar(100)
- bo_target_open — char(10)
- bo_subject — varchar(255)
- bo_content — mediumtext
- bo_link — mediumtex
- bo_file — mediumtex
- bo_file_org — mediumtext
- bo_hit — int
- bo_good — int
- bo_nogood — int
- use_at — char(1)
- wr_id — char(50)
- wr_pass — char(50)
- wr_name — char(50)
- wr_email — varchar(255)
- wr_datetime — datetime
- wr_lasttime — datetime — NOT NULL
- wr_ip — char(15)
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of g5_content (im_bbs_gather)
- idx — int — Primary key — NOT NULL
- bo_parent — int
- bo_depth (bo_deptht) — int
- bo_category — varchar(255)
- bo_notice — enum('Y','N')
- bo_depart — varchar(255)
- bo_secert — enum('Y','N')
- bo_sdate — date
- bo_edate — date
- bo_target_depart — varchar(100)
- bo_target_open — char(10)
- bo_subject — varchar(255)
- bo_content — mediumtext
- bo_link — mediumtex
- bo_file — mediumtex
- bo_file_org — mediumtext
- bo_hit — int
- bo_good — int
- bo_nogood — int
- use_at — char(1)
- wr_id — char(50)
- wr_pass — char(50)
- wr_name — char(50)
- wr_email — varchar(255)
- wr_datetime — datetime
- wr_lasttime — datetime — NOT NULL
- wr_ip — char(15)
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of g5_content (im_bbs_depart)
- idx — int — Primary key — NOT NULL
- bo_parent — int
- bo_depth (bo_deptht) — int
- bo_category — varchar(255)
- bo_notice — enum('Y','N')
- bo_depart — varchar(255)
- bo_secert — enum('Y','N')
- bo_sdate — date
- bo_edate — date
- bo_target_depart — varchar(100)
- bo_target_open — char(10)
- bo_subject — varchar(255)
- bo_content — mediumtext
- bo_link — mediumtex
- bo_file — mediumtex
- bo_file_org — mediumtext
- bo_hit — int
- bo_good — int
- bo_nogood — int
- use_at — char(1)
- wr_id — char(50)
- wr_pass — char(50)
- wr_name — char(50)
- wr_email — varchar(255)
- wr_datetime — datetime
- wr_lasttime — datetime — NOT NULL
- wr_ip — char(15)
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of g5_content (im_bbs_bbs12)
- idx — int — Primary key — NOT NULL
- bo_parent — int
- bo_depth (bo_deptht) — int
- bo_category — varchar(255)
- bo_notice — enum('Y','N')
- bo_depart — varchar(255)
- bo_secert — enum('Y','N')
- bo_sdate — date
- bo_edate — date
- bo_target_depart — varchar(100)
- bo_target_open — char(10)
- bo_subject — varchar(255)
- bo_content — mediumtext
- bo_link — mediumtex
- bo_file — mediumtex
- bo_file_org — mediumtext
- bo_hit — int
- bo_good — int
- bo_nogood — int
- use_at — char(1)
- wr_id — char(50)
- wr_pass — char(50)
- wr_name — char(50)
- wr_email — varchar(255)
- wr_datetime — datetime
- wr_lasttime — datetime — NOT NULL
- wr_ip — char(15)
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of g5_content (im_bbs_bbs11)
- idx — int — Primary key — NOT NULL
- bo_parent — int
- bo_depth (bo_deptht) — int
- bo_category — varchar(255)
- bo_notice — enum('Y','N')
- bo_depart — varchar(255)
- bo_secert — enum('Y','N')
- bo_sdate — date
- bo_edate — date
- bo_target_depart — varchar(100)
- bo_target_open — char(10)
- bo_subject — varchar(255)
- bo_content — mediumtext
- bo_link — mediumtex
- bo_file — mediumtex
- bo_file_org — mediumtext
- bo_hit — int
- bo_good — int
- bo_nogood — int
- use_at — char(1)
- wr_id — char(50)
- wr_pass — char(50)
- wr_name — char(50)
- wr_email — varchar(255)
- wr_datetime — datetime
- wr_lasttime — datetime — NOT NULL
- wr_ip — char(15)
Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of g5_content (im_bbs_bbs10)
- idx — int — Primary key — NOT NULL
- bo_parent — int
- bo_depth (bo_deptht) — int
- bo_category — varchar(255)
- bo_notice — enum('Y','N')
- bo_depart — varchar(255)
- bo_secert — enum('Y','N')
- bo_sdate — date
- bo_edate — date
- bo_target_depart — varchar(100)
- bo_target_open — char(10)
- bo_subject — varchar(255)
- bo_content — mediumtext
- bo_link — mediumtex
- bo_file — mediumtex
- bo_file_org — mediumtext
- bo_hit — int
- bo_good — int
- bo_nogood — int
- use_at — char(1)
- wr_id — char(50)
- wr_pass — char(50)
- wr_name — char(50)
- wr_email — varchar(255)
- wr_datetime — datetime
- wr_lasttime — datetime — NOT NULL
- wr_ip — char(15)
Copy Of Copy Of Copy Of Copy Of Copy Of g5_content (im_bbs_bbs04)
- idx — int — Primary key — NOT NULL
- bo_parent — int
- bo_depth (bo_deptht) — int
- bo_category — varchar(255)
- bo_notice — enum('Y','N')
- bo_depart — varchar(255)
- bo_secert — enum('Y','N')
- bo_sdate — date
- bo_edate — date
- bo_target_depart — varchar(100)
- bo_target_open — char(10)
- bo_subject — varchar(255)
- bo_content — mediumtext
- bo_link — mediumtex
- bo_file — mediumtex
- bo_file_org — mediumtext
- bo_hit — int
- bo_good — int
- bo_nogood — int
- use_at — char(1)
- wr_id — char(50)
- wr_pass — char(50)
- wr_name — char(50)
- wr_email — varchar(255)
- wr_datetime — datetime
- wr_lasttime — datetime — NOT NULL
- wr_ip — char(15)
Copy Of Copy Of Copy Of Copy Of g5_content (im_bbs_bbs03)
- idx — int — Primary key — NOT NULL
- bo_parent — int
- bo_depth (bo_deptht) — int
- bo_category — varchar(255)
- bo_notice — enum('Y','N')
- bo_depart — varchar(255)
- bo_secert — enum('Y','N')
- bo_sdate — date
- bo_edate — date
- bo_target_depart — varchar(100)
- bo_target_open — char(10)
- bo_subject — varchar(255)
- bo_content — mediumtext
- bo_link — mediumtex
- bo_file — mediumtex
- bo_file_org — mediumtext
- bo_hit — int
- bo_good — int
- bo_nogood — int
- use_at — char(1)
- wr_id — char(50)
- wr_pass — char(50)
- wr_name — char(50)
- wr_email — varchar(255)
- wr_datetime — datetime
- wr_lasttime — datetime — NOT NULL
- wr_ip — char(15)
Copy Of Copy Of Copy Of g5_content (im_bbs_bbs02)
- idx — int — Primary key — NOT NULL
- bo_parent — int
- bo_depth (bo_deptht) — int
- bo_category — varchar(255)
- bo_notice — enum('Y','N')
- bo_depart — varchar(255)
- bo_secert — enum('Y','N')
- bo_sdate — date
- bo_edate — date
- bo_target_depart — varchar(100)
- bo_target_open — char(10)
- bo_subject — varchar(255)
- bo_content — mediumtext
- bo_link — mediumtex
- bo_file — mediumtex
- bo_file_org — mediumtext
- bo_hit — int
- bo_good — int
- bo_nogood — int
- use_at — char(1)
- wr_id — char(50)
- wr_pass — char(50)
- wr_name — char(50)
- wr_email — varchar(255)
- wr_datetime — datetime
- wr_lasttime — datetime — NOT NULL
- wr_ip — char(15)
Copy Of Copy Of Copy Of g5_content2 (im_member_favorite)
- idx — int — Primary key — NOT NULL
- m_id — varchar(50) — NOT NULL
- bbs_id — char(50) — NOT NULL
- bbs_category — char(50) — NOT NULL
- order — int — NOT NULL
- reg_dt — datetime — NOT NULL
Copy Of Copy Of Copy Of g5_content22 (im_one_notice)
- idx — int — Primary key — NOT NULL
- one_no — int — NOT NULL
- one_title — varchar(200) — NOT NULL
- one_content — text — NOT NULL
- one_url — varchar(255) — NOT NULL
- one_order — int
- use_at — char(1) — NOT NULL
- reg_dt — datetime — NOT NULL
- reg_id — varchar(50)
- reg_ip — char(15)
- updt_dt — datetime
- updt_up — char(15) — NOT NULL
Copy Of Copy Of g5_content (im_bbs_bbs01)
- idx — int — Primary key — NOT NULL
- bo_parent — int
- bo_depth (bo_deptht) — int
- bo_category — varchar(255)
- bo_notice — enum('Y','N')
- bo_depart — varchar(255)
- bo_secert — enum('Y','N')
- bo_sdate — date
- bo_edate — date
- bo_target_depart — varchar(100)
- bo_target_open — char(10)
- bo_subject — varchar(255)
- bo_content — mediumtext
- bo_link — mediumtex
- bo_file — mediumtex
- bo_file_org — mediumtext
- bo_hit — int
- bo_good — int
- bo_nogood — int
- use_at — char(1)
- wr_id — char(50)
- wr_pass — char(50)
- wr_name — char(50)
- wr_email — varchar(255)
- wr_datetime — datetime
- wr_lasttime — datetime — NOT NULL
- wr_ip — char(15)
Copy Of Copy Of g5_content2 (im_bbs_group)
- idx — int — Primary key — NOT NULL
- grp_no — int — NOT NULL
- grp_name — varchar(100) — NOT NULL
- grp_depart — varchar(255) — NOT NULL
- grp_mem — varchar(255) — NOT NULL
- grp_mem_id — varchar(255)
- grp_memo — text
- use_at — char(1) — NOT NULL
- reg_dt — datetime — NOT NULL
- reg_id — varchar(50)
- reg_ip — char(15)
- updt_dt — datetime
- updt_up — char(15) — NOT NULL
Copy Of Copy Of g5_content22 (im_banner)
- idx — int — Primary key — NOT NULL
- ba_no — int — NOT NULL
- ba_gubun — char(50) — NOT NULL
- ba_memo — varchar(200)
- ba_order — int(11) — NOT NULL
- ba_target — char(10) — NOT NULL
- ba_url — varchar(255) — NOT NULL
- use_at — char(1) — NOT NULL
- reg_dt — datetime — NOT NULL
- reg_id — varchar(50)
- reg_ip — char(15)
- updt_dt — datetime
- updt_up — char(15) — NOT NULL
Copy Of Copy Of g5_content3 (im_sys_code)
- NO — int — Primary key — NOT NULL
- SYS_CODE — varchar(7) — NOT NULL
- SYS_CODE_NM — varchar(100) — NOT NULL
- CL_CODE — varchar(8) — Foreign key → Copy Of g5_content3.CL_CODE — NOT NULL
- UPPER_CODE — varchar(8) — NOT NULL
- USE_AT — varchar(1) — NOT NULL
- RM — varchar(2000) — NOT NULL
- UPDUSR_ID — varchar(20) — NOT NULL
- UPDT_DT — datetime — NOT NULL
- UPDT_IP — varchar(50) — NOT NULL
Copy Of g5_content (im_pohang_staff)
- idx — int — Primary key — NOT NULL
- search_key — varchar(255) — Primary key — NOT NULL
- field_subject — varchar(255)
- field_phone — varchar(255)
- field_position — varchar(255)
- field_deptname — varchar(255)
Copy Of g5_content2 (im_popup_zone)
- idx — int — Primary key — NOT NULL
- pop_no — char(50) — NOT NULL
- pop_text — varchar(255) — NOT NULL
- pop_url — varchar(255) — NOT NULL
- pop_target — char(10) — NOT NULL
- pop_memo — varchar(255)
- pop_img_nm — varchar(255)
- pop_img_org — varchar(255)
- pop_order — int(11) — NOT NULL
- use_at — char(1) — NOT NULL
- reg_dt — datetime — NOT NULL
- reg_id — varchar(50)
- reg_ip — char(15)
- updt_dt — datetime
- updt_up — char(15) — NOT NULL
Copy Of g5_content3 (im_cl_code)
- NO — int — Primary key — NOT NULL
- CL_CODE — varchar(8) — Primary key — NOT NULL
- CL_CODE_NM — varchar(100) — NOT NULL
- SYS_CODE_ALPHA — varchar(10) — NOT NULL
- USE_AT — varchar(1) — NOT NULL
- RM — varchar(2000) — NOT NULL
- UPDUSR_ID — varchar(20) — NOT NULL
- UPDT_DT — datetime — NOT NULL
- UPDT_IP — varchar(50) — NOT NULL
Copy Of g5_member (im_bbs_conifg)
- mb_no (idx) — int(11) — Primary key — NOT NULL
- bbs_no — int — NOT NULL
- bbs_id — varchar(50) — NOT NULL
- bbs_nm — varchar(200) — NOT NULL
- bbs_admin — varchar(255) — NOT NULL
- bbs_list_level — char(50)
- bbs_write_level — char(50)
- bbs_read_level — char(50)
- bbs_reply_level — char(50)
- bbs_category — varchar(255)
- bbs_category_use — enum('Y','N') — NOT NULL
- bbs_main_use — enum('Y','N')
- bbs_main01_use — enum('Y','N') — NOT NULL
- bbs_main02_use — enum('Y','N') — NOT NULL
- bbs_notice_use — enum('Y','N') — NOT NULL
- bbs_secert_use — enum('Y','N') — NOT NULL
- bbs_reply_subject_use — enum('Y','N') — NOT NULL
- bbs_term_use — enum('Y','N') — NOT NULL
- bbs_period_use — enum('Y','N') — NOT NULL
- bbs_depart_use — enum('Y','N') — NOT NULL
- bbs_comment_use — enum('Y','N') — NOT NULL
- bbs_ordby — int — NOT NULL
- bbs_file_num — int — NOT NULL
- bbs_memo — tinytext
- use_at — char(1) — NOT NULL
- reg_dt — datetime — NOT NULL
- reg_id — varchar(50) — NOT NULL
- reg_ip — char(15) — NOT NULL
- updt_dt — datetime
- updt_ip — char(15)
Copy Of g5_menu (im_bbs_file)
- idx — int(11) — Primary key — NOT NULL
- bbs_id — varchar(50) — NOT NULL
- bo_id — int — NOT NULL
- bo_id_depth — int
- bo_file — varchar(255) — NOT NULL
- bo_file_org — varchar(255) — NOT NULL
g5_member (im_member)
- mb_no (idx) — int(11) — Primary key — NOT NULL
- m_id — varchar(255) — Foreign key → Copy Of g5_content.search_key — NOT NULL
- mb_password (m_secret_key) — varchar(50) — NOT NULL
- mb_name (m_name) — varchar(255) — NOT NULL
- m_tek (m_tel) — char(20) — NOT NULL
- m_hp — char(20) — NOT NULL
- m_email — varchar(200) — NOT NULL
- m_birth — char(20) — NOT NULL
- m_sex — enum('M','F') — NOT NULL
- m_zip — char(6) — NOT NULL
- m_address — varchar(255) — NOT NULL
- m_address_detail — varchar(255) — NOT NULL
- m_level — char(20) — NOT NULL
- m_position — char(20) — NOT NULL
- m_depart — varchar(100) — NOT NULL
- m_depart1 — varchar(100) — NOT NULL
- m_depart2 — varchar(100) — NOT NULL
- m_gubun — char(20) — NOT NULL
- mb_addr_jibeon — varchar(255) — NOT NULL
- m_sync_id — varchar(100) — NOT NULL
- use_at — char(1) — NOT NULL
- reg_dt — datetime — NOT NULL
- reg_id — varchar(50) — NOT NULL
- reg_ip — char(15) — NOT NULL
- updt_dt — datetime
- updt_ip — char(15)
g5_menu (im_bbs_comment)
- idx — int(11) — Primary key — NOT NULL
- bo_id — int — NOT NULL
- bbs_id — varchar(50) — NOT NULL
- comment_content — text — NOT NULL
- wr_id — varchar(50) — NOT NULL
- wr_name — char(50) — NOT NULL
- wr_ip — char(15) — NOT NULL
- wr_datetime — datetime — NOT NULL
- updt_datetime — datetime — NOT NULL