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)