homepage
Tables (5)
Company (오시는 길)
- id (Key) — bigint(20) — Primary key — NOT NULL
- image (Field) — varchar(512)
- name (Field2) — varchar(100)
- address (Field6) — varchar(255)
- email (Field3) — varchar(320)
- tel (Field4) — varchar(100)
- fax (Field5) — varchar(100)
- created (Field7) — date
History (연혁)
- id (Key) — bigint(20) — Primary key — NOT NULL
- historyDate (Field) — date
- contents (Field3) — varchar(150)
Solution (솔루션)
- id (Key) — bigint(20) — Primary key — NOT NULL
- image (Field) — varchar(512)
- title (Field2) — varchar(100)
- subTitle (Field3) — varchar(200)
- priority (Field5) — tinyint(10)
SolutionContents (솔루션 기능 설명)
- id (Key) — bigint(20) — Primary key — NOT NULL
- solutionId (Key2) — bigint(20) — Foreign key → Solution.id — NOT NULL
- priority (Field) — tinyint(2)
- contents (Field2) — varchar(255)
User (관리자 계정)
- id (Key) — bigint(20) — Primary key — NOT NULL
- email (Field) — varchar(320)
- password (Field2) — varchar(64)
- name (Field3) — varchar(100)
- phone (Field4) — varchar(100)