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