임시
테이블 (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