rentcarProject

Tables (3)

CAR (차량)

  • CARCODE (차코드) — INT — Primary key — NOT NULL
  • CARTYPE (차종류) — nvarchar(30)
  • CARNAME (차이름) — nvarchar(30)
  • CARSIZE (차사이즈) — nvarchar(30)
  • CARNUM (차넘버) — nvarchar(30)
  • USEFLAG (차현재상태) — nvarchar(1)
  • CARREGIST (자동차등록일) — DATETIME
  • CARMAKER (차회사) — navarchar(30)
  • RENTPRICE (렌트1일 가격) — INT
  • MAKER (등록자) — nvarchar(30)
  • MAKEDATE (DB등록날짜) — DATETIME
  • EDITOR (수정자) — nvarchar(30)
  • EDITDATE (수정날짜) — datetime
  • KM (주행거리) — nvarchar(10)
  • CARIMG (차사진) — image

RENT (렌트)

  • RENTID (렌트ID) — varchar(10) — Primary key — NOT NULL
  • CLIENTID (고객ID) — INT — Foreign key → RENTUSER.CLIENTID — NOT NULL
  • CARCODE (차코드) — INT — Foreign key → CAR.CARCODE — NOT NULL
  • RENTSTARTDATE (렌트시작일) — DATETIME
  • RETURNDATE (반납예정날짜) — DATETIME
  • REALRETURNDATE (실제반납일) — DATETIME
  • RENTFLAG (반납여부) — varchar(5)
  • INSURANCETYPE (보험종류) — varchar(5)
  • COST (예상비용) — INT
  • FIRSTDATE (등록일) — DATETIME
  • MAKER (등록자) — varchar(10)
  • IMGCONTRACT (계약서 사진) — IMAGE
  • EXTRPCOST (추가비용) — INT

RENTUSER (고객)

  • CLIENTID (고객ID) — INT — Primary key — NOT NULL
  • CLIENTNAME (고객이름) — VARCHAR(50)
  • AGE (나이) — INT
  • GENDER (성별) — VARCHAR(1)
  • ADDRESS (주소) — VARCHAR(100)
  • FIRSTDATE (등록일) — DATETIME
  • PHONENUMBER (전화번호) — VARCHAR(30)
  • LICENSE (민증사진) — IMAGE
  • USERCLASS (고객등급) — VARCHAR(10)
  • MAKER (등록자) — VARCHAR(10)
  • Field