Parking
Tables (12)
DiscountTicket (할인권)
- dticket_id (Key2) — int — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → User.user_id — NOT NULL
- discount_type (Field5) — enum
- discount_price (Field) — int
- discount_rate (Field2) — int
- expire_date (Field3) — date
- is_used (Field4) — boolean
- is_active (Field6) — boolean
- use_date (Field7) — date
Howtopay (결제 수단)
- howtopay_id (Key2) — int — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → User.user_id — NOT NULL
- payment_token (Field) — string
Inquiry (문의)
- inquiry_id (Key2) — int — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → User.user_id — NOT NULL
- is_cleared (Field) — boolean
- inquiry_request (Field2) — date
- inquiry_response (Field3) — date
Nonpayment (미납금)
- nonpay_id (Key2) — int — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → User.user_id — NOT NULL
- parking_use_id (Key22) — int — Foreign key → ParkingUse.parking_use_id — NOT NULL
- nonpaid_amount (Field) — int
- due_date (Field2) — date
- is_paid (Field3) — boolean
- paid_date (Field4) — date
ParkingReservation (주차장 예약)
- reservation_id (Key2) — int — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → User.user_id — NOT NULL
- car_id (Key22) — int — Foreign key → UserCar.car_id — NOT NULL
- spot_id (Key3) — int — Foreign key → ParkingSpot.spot_id — NOT NULL
- start_time (Field) — date
- end_time (Field2) — date
- reserve_status (Field3) — enum
ParkingSpot (주차공간)
- spot_id (Key) — int — Primary key — NOT NULL
- location (Field) — string
- car_num (Field3) — int
- electric_zone (Field4) — boolean
- is_available (Field2) — boolean
- is_elec_available (Field5) — boolean
ParkingUse (주차장 이용 내역)
- parking_use_id (Key2) — int — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → User.user_id — NOT NULL
- car_id (Key22) — int — Foreign key → UserCar.car_id — NOT NULL
- spot_id (Key3) — int — Foreign key → ParkingSpot.spot_id — NOT NULL
- start_time (Field) — date
- end_time (Field2) — date
- cost (Field3) — int
- using_status (Field4) — enum
- is_paid (Field5) — boolean
PaymentHistory (결제 내역)
- history_id (Key2) — int — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → User.user_id — NOT NULL
- parkinguse_id (Key22) — int — Foreign key → ParkingUse.parking_use_id — NOT NULL
- howtopay_id (Key23) — int — Foreign key → Howtopay.howtopay_id — NOT NULL
- nonpay_id (Key24) — int — Foreign key → Nonpayment.nonpay_id — NOT NULL
- paid_amount (Field) — int
- paid_date (Field2) — date
RemainSTicket (남은 정기권)
- remain_id (Key) — int — Primary key — NOT NULL
- sticket_id (Key2) — int — Foreign key → SeasonTicket.sticket_id — NOT NULL
- remain_count (Field) — int
- reamain_time (Field2) — int
- last_updated_date (Field3) — date
SeasonTicket (정기권)
- sticket_id (Key2) — int — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → User.user_id — NOT NULL
- ticket_type (Field) — enum
- total_count (Field2) — int
- total_time (Field3) — int
- end_date (Field4) — date
- is_active (Field5) — boolean
User (유저 정보)
- user_id (Key) — int — Primary key — NOT NULL
- email (Field) — string
- password (Field2) — string
- name (Field3) — string
- nickname (Field4) — string
- kakao_user_id (Field5) — int
- naver_user_id (Field6) — int
- google_user_id (Field7) — int
UserCar (유저차량 정보)
- car_id (Key2) — int — Primary key — NOT NULL
- user_id (Key) — int — Foreign key → User.user_id — NOT NULL
- car_number (Field) — string
- car_model (Field2) — string