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 — 고객등급