임시

테이블 (7)

Car_Info

  • Car_Info_Id — int — 기본 키 — NOT NULL
  • User_Id — int — 외래 키 → User.User_Id — NOT NULL
  • Car_number — varchar(30)

Parking_Area_Info

  • Parking_Area_Info_Id — int — 기본 키 — NOT NULL
  • name — varchar(30)
  • GPS_location — Point
  • Structure — varchar(255)

Parking_Codinate_Info

  • Parking_Codinate_Info_Id — int — 기본 키 — NOT NULL
  • Parking_Area_Info_Id — int — 외래 키 → Parking_Area_Info.Parking_Area_Info_Id — NOT NULL
  • Idx — varchar(30)
  • Codiante_XY — Point
  • Codiante_Z — int
  • Front_Codiante_XY — Point
  • Front_Codiante_ZW — Point

Robot_Info

  • Robot_Info_Id — int — 기본 키 — NOT NULL
  • Parking_Area_Info_Id — int — 외래 키 → Parking_Area_Info.Parking_Area_Info_Id — NOT NULL
  • State — Boolean

Robot_Log

  • Robot_Log_Id — int — 기본 키 — NOT NULL
  • Robot_Info_Id — int — 외래 키 → Robot_Info.Robot_Info_Id — NOT NULL
  • Parking_Area_Info_Id — int — 외래 키 → Robot_Info.Parking_Area_Info_Id — NOT NULL
  • State — varchar(30)
  • location — Point
  • Time — Date

User

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

Working_Schedule

  • Working_Schedule_Id — int — 기본 키 — NOT NULL
  • User_Id — int — 외래 키 → Car_Info.User_Id — NOT NULL
  • Car_Info_Id — int — 외래 키 → Car_Info.Car_Info_Id — NOT NULL
  • Parking_Codinate_Info_Id — int — 외래 키 → Parking_Codinate_Info.Parking_Codinate_Info_Id — NOT NULL
  • Parking_Area_Info_Id — int — 외래 키 → Parking_Codinate_Info.Parking_Area_Info_Id — NOT NULL
  • Charge_Time — int
  • Is_Finished — Boolean
  • Time — Date