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)