parking
Tables (7)
Agency (Untitled3)
- agencyNo (seq) — number — Primary key — NOT NULL
- memberNo (seq2) — number — Foreign key → MemberDTO.memberNo — NOT NULL
- nameOfAgency (name) — varchar2(10)
- contactName (manager) — varchar2(10)
- contactPhone (phone) — varchar2(13)
- issueOfDate (Date) — date
- expireOfDate (DATE) — varchar2(11)
- countOfExtend (count) — number
- paid — number
- uesdCount (COUNT) — number
- reg_date (DATE2) — date
MemberDTO (DTO)
- memberNo (seq) — number — Primary key — NOT NULL
- memberId (Field) — varchar2(20)
- password (pw) — varchar2(20)
- email — varchar2(30)
- nameOfParkingArea (name) — varchar2(10)
- phone (contact) — varchar2(13)
- reg_date (systime) — date
- device_token (Field2) — varchar2(50)
cost (Untitled)
- memberNo (seq) — number — Foreign key → MemberDTO.memberNo — NOT NULL
- addtionalCost — number
- addtionalTime — number
- baseCost — number
- baseTime — number
- maxCost — number
- maxTime (maxHour) — number
- reg_date (sysdate) — date
coupon (Untitled6)
- usedNo (seq) — number — Foreign key → listOfParked.usedNo — NOT NULL
- memberNo (seq4) — number — Foreign key → MemberDTO.memberNo — NOT NULL
- target_tyoe (type) — varchar2(10)
- targetNo (Field) — number
listOfParked (Untitled4)
- usedNo (seq) — number — Primary key — NOT NULL
- memberNo (seq2) — number — Foreign key → MemberDTO.memberNo — NOT NULL
- memberNo (seq3) — number — Foreign key → cost.memberNo — NOT NULL
- plateNumOfCar (number) — varchar2(15)
- currentOfState (state) — varchar2(3)
- timeOfused (time) — number
- timeOfParked (time1) — date
- timeOfOut (time2) — date
- paid (money) — number
- coupon (isUsed) — varchar2(5)
- photoLink (url) — varchar2(300)
photo (Untitled5)
- photoId (id) — number — Primary key — NOT NULL
- usedNo (seq2) — number — Foreign key → listOfParked.usedNo — NOT NULL
- dir (direction) — varchar2(300)
- filename (name) — varchar2(100)
- originalName (name1) — varchar2(100)
- fileType (type) — varchar2(30)
- fileSize (size) — number
- req_date (date) — date
regularMember (Untitled2)
- regularNo (seq) — number — Primary key — NOT NULL
- memberNo (seq2) — number — Foreign key → MemberDTO.memberNo — NOT NULL
- plateNumOfCar (plateNumber) — varchar2(9)
- guestName (name) — varchar2(4)
- guestContact (number) — varchar2(13)
- issueOfDate (date) — date
- expireOfDate (Date) — varchar2(11)
- countOfExtend (count) — number
- usedCount (cnt) — number