CJ컴퍼니
테이블 (13)
admin (관리자테이블)
- ad_no (int) — int — 기본 키 — NOT NULL
- ad_id (Field)
- ad_pw (Field2)
- ad_name (Field3)
architector (CopyOfCopyOfCopyOfUntitled22)
- a_num (Field) — primary key — 기본 키
- a_name (Field2)
- phone_num (Field3)
- addr (Field4)
- history (Field5)
- update_at (Field6)
- content (Field7)
banner (CopyOfCopyOfCopyOfCopyOfUntitled2)
- b_num (Field) — primary key — 기본 키
- logo_num (Field6) — primary key — 외래 키 → logo.logo_num
- img_path (Field2)
- title (Field3)
- descript (Field4)
- update_at (Field5)
construct_board (Untitled)
- board_num (int) — int — 기본 키
- ad_no (int2) — int — 외래 키 → admin.ad_no — NOT NULL
- title (F)
- content (Field)
- created_at (Field4)
- update_at (Field5)
- board_type (Field6)
- notice (Field7)
cooper_company (CopyOfCopyOfUntitled22)
- c_num (Field) — primary key — 기본 키
- company_name (Field2)
- contact_name (Field3)
- contact_phone_num (Field4)
- content (Field5)
- update_at (Field6)
counselor (CopyOfUntitled22)
- c_num (Field) — primary key — 기본 키
- l_num (Field6) — primary key — 외래 키 → living_space.l_num
- c_name (Field2)
- phone_num (Field3)
- want_time (Field4)
- living_space (Field5)
- area_flag (Field7)
- work_space (Field8)
- c_status (Field9)
- update_at (Field10)
file (Untitled4)
- file_num (Key) — int — 기본 키 — NOT NULL
footer (CopyOfCopyOfUntitled2)
- f_num (Field) — primary key — 기본 키
- logo_num (Field4) — primary key — 외래 키 → logo.logo_num
- f_content (Field2)
- update_at (Field5)
- allright (Field8)
- icon_iamge_path (Field3)
icon (CopyOfCopyOfCopyOfUntitled2)
- i_num (Field) — primary key — 기본 키
- i_image_path (Field2)
- updated_at (Field3)
- i_content (Field4)
- i_descript (Field5)
- i_title (Field6)
living_space (CopyOfCopyOfUntitled222)
- l_num (Field) — primary key — 기본 키
- l_title (Field2)
- update_at (Field5)
logo (Untitled3)
- logo_num (Field) — primary key — 기본 키
- logo_img_path (Field2)
- update_at (Field3)
- logo_version (Field4)
menu (CopyOfUntitled2)
- m_num (Field) — primary key — 기본 키
- logo_num (Field5) — primary key — 외래 키 → logo.logo_num
- m_name (Field2)
- update_at (Field4)
- show_flag (Field3)
- sub_menu_num (Field8)
room_size (Untitled2)
- room_num (Field) — primary key — 기본 키
- r_name (Field2)
- price (Field3)
- update_at (Field4)