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