OneLine

Tables (4)

Account (dd)

  • ID (Key) — int — Primary key — NOT NULL
  • Name (Field) — string
  • Account (Field2) — string
  • Password (Field3) — string
  • Auth (Field4) — string
  • Address (Field5) — string
  • HP (Field6) — string
  • Mail (Field7) — string

Consult (Untitled2)

  • ID (Key) — int — Primary key — NOT NULL
  • Customer (Key2) — int — Foreign key → Customer.ID — NOT NULL
  • Manager (Key22) — int — Foreign key → Customer.Manager — NOT NULL — 담당자
  • ConsultDate (Field) — timedate
  • ReservationTime (Field2) — timedate
  • Result (Field3) — string

Contract (Untitled3)

  • ID (Key) — int — Primary key — NOT NULL
  • Field

Customer (Untitled)

  • ID (Key) — int — Primary key — NOT NULL
  • Manager (Key2) — int — Foreign key → Account.ID — NOT NULL — 담당자
  • Name (Field) — string
  • Group (Field2) — string — NOT NULL — 소속그룳
  • Sex (Field3) — string — NOT NULL — 성별
  • Age (Field5) — string — NOT NULL — 나이
  • HopeCar (Field6) — string — NOT NULL — 희망차종
  • Class (Field7) — string — NOT NULL — 희망차종
  • Local (Field8) — string — NOT NULL — 지역
  • Option (Field9) — string — NOT NULL — 옵션
  • Term (Field10) — string — NOT NULL — 기간
  • Distance (Field11) — string — NOT NULL — 약정주행거리
  • Amount (Field12) — int — NOT NULL — 초기금액
  • Balance (Field13) — string — NOT NULL — 대차여부
  • Mail (Field14) — string — NOT NULL — e-mail
  • Fax (Field15) — string — NOT NULL — Fax
  • Result (Field16) — string — NOT NULL — 심사결과
  • Status (Field17) — string — NOT NULL — 상태
  • RegDate (Field18) — timedate — NOT NULL — 등록일
  • ChkMsgRecv (Field19) — Bool — NOT NULL — 문자수신여부(Checkbox)
  • Comment (Field20) — string
  • Rating (Field21) — string — NOT NULL — 고객등급