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)