INSITE

Tables (15)

admin (Untitled16)

  • id (Key) — Primary key — NOT NULL
  • 관리자 비밀번호 (Field)

companies (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • inquiry_id (Key2) — Foreign key → inquiries.id — NOT NULL
  • admin_id (Key3) — Foreign key → admin.id — NOT NULL
  • design_id (Key4) — Foreign key → design.id — NOT NULL
  • 고객사명 (Field3)

design (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • 폰트 (Field)
  • 로고파일 (Field4)
  • 소개서파일 (Field5)
  • 추가요청사항 (Field6)
  • 메인컬러 (Field2)
  • 서브컬러 (Field3)

detail_pages (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • selected_module_id (Key2) — Foreign key → selected_modules.id — NOT NULL
  • id (Key4) — Foreign key → selected_modules.id — NOT NULL
  • 작성일 (Field)

downloads (Untitled15)

  • id (Key) — Primary key — NOT NULL
  • detail_page_id (Key22) — Foreign key → detail_pages.selected_module_id — NOT NULL
  • id (Key4) — Foreign key → detail_pages.id — NOT NULL
  • 배경이미지 (Field)
  • 배경내용 (Field2)
  • 버튼명 (Field3)
  • 다운로드 ㅎ파일 (Field4)

inquiries (Untitled)

  • id (Key) — Primary key — NOT NULL
  • 이름 (Field)
  • 이메일 (Field2)
  • 휴대폰번호 (Field3)
  • 폼 제출일 (Field5)
  • 폼 유형 (Field4)

inquiries (Untitled14)

  • id (Key) — Primary key — NOT NULL
  • detail_page_id (Key22) — Foreign key → detail_pages.selected_module_id — NOT NULL
  • id (Key4) — Foreign key → detail_pages.id — NOT NULL
  • 문의내용 (Field4)
  • 휴대폰번호 (Field)
  • 이메일 (Field2)
  • 답변상태 (Field3)

module_details (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • selected_module_id (Key2) — Foreign key → selected_modules.id — NOT NULL
  • id (Key4) — Foreign key → selected_modules.id — NOT NULL
  • Field

module_name (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • module_type_id (Key2) — Foreign key → module_type.id — NOT NULL
  • 세부 모듈명 (Field2)

module_type (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • 모듈타입명 (Field) — 서비스, 뉴스, 문의하기 등등

news (Untitled12)

  • id (Key) — Primary key — NOT NULL
  • detail_page_id (Key22) — Foreign key → detail_pages.selected_module_id — NOT NULL
  • id (Key4) — Foreign key → detail_pages.id — NOT NULL
  • 뉴스유형 (Field)
  • 타이틀 (Field3)
  • 링크 (Field2)
  • 썸네일 이미지 (Field4)
  • 뉴스사 (Field5)

notice (Untitled11)

  • id (Key) — Primary key — NOT NULL
  • detail_page_id (Key22) — Foreign key → detail_pages.selected_module_id — NOT NULL
  • id (Key4) — Foreign key → detail_pages.id — NOT NULL
  • 타이틀 (Field)
  • 내용 (Field2)
  • 상위고정여부 (Field3)

partners (Untitled13)

  • id (Key) — Primary key — NOT NULL
  • detail_page_id (Key22) — Foreign key → detail_pages.selected_module_id — NOT NULL
  • id (Key4) — Foreign key → detail_pages.id — NOT NULL
  • 국문명 (Field)
  • 영문명 (Field2)
  • 이미지파일 (Field3)

selected_modules (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • company_id (Key2) — Foreign key → companies.id — NOT NULL
  • module_name_id (Key3) — Foreign key → module_name.module_type_id — NOT NULL
  • id (Key4) — Foreign key → companies.design_id — NOT NULL
  • 모듈순서 (Field)
  • 모듈 강조여부 (Field2)

service (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • detail_page_id (Key22) — Foreign key → detail_pages.selected_module_id — NOT NULL
  • id (Key4) — Foreign key → detail_pages.id — NOT NULL
  • 타이틀 (Field)
  • 내용 (Field2)
  • 이미지 (Field3)
  • 버튼명 (Field4)
  • 버튼링크 (Field5)