첫 주 DB

테이블 (6)

Car_info

  • Car_Id — int — 기본 키 — NOT NULL
  • Pay_Info_Id — int — 외래 키 → Pay_Info.Pay_Info_Id — NOT NULL
  • Parking_Area_info_id — int — 외래 키 → Parking_Area_info.Parking_Area_Info_Id — NOT NULL
  • User_Id — int — 외래 키 → User.User_Id — NOT NULL
  • Car_parking_location_Info — int

Parking_Area_info

  • Parking_Area_Info_Id — int — 기본 키 — NOT NULL
  • Parking_Area_name — varchar(30)

Pay_Info

  • Pay_Info_Id — int — 기본 키 — NOT NULL
  • pay_charge — int

Robot_info

  • Robot_Info_Id — int — 기본 키 — NOT NULL
  • Parking_Area_Info_Id — int — 외래 키 → Parking_Area_info.Parking_Area_Info_Id — NOT NULL
  • working_schedule_Id — int — 외래 키 → Working_Schedule.working_schedule_Id — NOT NULL
  • location — int
  • battery — int
  • working_status — varchar(30)

User

  • User_Id — int — 기본 키 — NOT NULL
  • username — varchar(30)
  • password — varchar(30)
  • phone_number — varchar(30)
  • email — varchar(30)
  • profile_img — ImageField
  • is_superuser — BooleanField

Working_Schedule

  • working_schedule_Id — int — 기본 키 — NOT NULL
  • car_location — int
  • charge_Info — int