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