parking

Tables (10)

User (회원)

  • id (식별자(User)) — int — Primary key — NOT NULL
  • role (구분) — String
  • username (사용자 이름(id)) — String
  • password (비밀번호) — String
  • name (이름) — String
  • age (나이) — int
  • provider (인증제공자(Naver, Kakao, Google)) — String
  • createdAt (생성일) — Date

alarmList (알람내역)

  • id (식별자(alarmList)) — int — Primary key — NOT NULL
  • id (식별자(alarmType)) — int — Foreign key → alarmType.id — NOT NULL
  • id (식별자(User)) — int — Foreign key → User.id — NOT NULL
  • createdAt (생성일) — Date

alarmType (알람종류)

  • id (식별자(alarmType)) — int — Primary key — NOT NULL
  • name (알람제목) — String
  • body (알람내용) — String
  • createdAt (생성일) — Date

inquiry (문의)

  • id (식별자(inquiry)) — int — Primary key — NOT NULL
  • id (식별자(User)) — int — Foreign key → User.id — NOT NULL
  • detail (문의내용) — String
  • status (문의처리여부) — boolean
  • requestDate (요청일) — Date
  • responseDate (응답일) — Date
  • createdAt (생성일) — Date

parkingLot (주차장 목록)

  • id (식별자(parkingLot)) — int — Primary key — NOT NULL
  • name (주차장 이름) — String
  • location (위치) — String
  • totalSpace (총주차가능공간) — int
  • occupiedSpace (주차된공간) — int
  • electircSpace (총전기차충전공간) — int
  • occupiedElectricSpace (충전중인전기차중전공간) — int
  • createdAt (생성일) — Date
  • id (식별자(pricedetail), 가격정보) — int — Foreign key → pricedetail.id — NOT NULL

parkingLotUsage (주차장 사용내역)

  • id (식별자(parkingLotUsage)) — int — Primary key — NOT NULL
  • id (식별자(parkingLot)) — int — Foreign key → parkingLot.id — NOT NULL
  • id (식별자(User)) — int — Foreign key → User.id — NOT NULL
  • id (식별자(payment)) — int — Foreign key → payment.id — NOT NULL
  • status (현재 상태(현재 주차 중)) — boolean
  • enterDate (입차일) — Date
  • leftDate (출차일) — Date
  • createdAt (생성일) — Date

payment (결제내역)

  • id (식별자(payment)) — int — Primary key — NOT NULL
  • id (식별자(User)) — int — Foreign key → User.id — NOT NULL
  • id (식별자(paymentRegistration) — int — Foreign key → paymentRegistration.id — NOT NULL
  • paymentMethod (결제수단) — String
  • status (결제성공여부) — boolean
  • paymentTime (결제시점시간) — Date
  • createdAt (생성일) — Date

paymentRegistration (결제수단등록)

  • id (식별자(paymentRegistration) — int — Primary key — NOT NULL
  • id (식별자(User)) — int — Foreign key → User.id — NOT NULL
  • paymentMethod (결제수단) — String
  • token (PG사가 제공한 토큰) — String
  • createdAt (생성일) — Date

pricedetail (가격 상세정보)

  • id (식별자(pricedetail)) — int — Primary key — NOT NULL
  • Field

vehicle (차량)

  • id (식별자(vehicle)) — int — Primary key — NOT NULL
  • id (식별자(User)) — int — Foreign key → User.id — NOT NULL
  • model (차량모델명) — String
  • number (차량번호) — String
  • isElectric (전기차여부) — boolean
  • createdAt (생성일) — createdAt