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