3주차 실구현 DB
테이블 (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_Coordinate_Info
- Parking_Coordinate_Info_Id — int — 기본 키 — NOT NULL
- Parking_Area_Info_Id — int — 외래 키 → Parking_Area_Info.Parking_Area_Info_Id — NOT NULL
- Idx — varchar(30)
- Coordinate_XY — Point
- Coordinate_Z — int
- Front_Coordinate_XY — Point
- Front_Coordinate_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)
- Robot_Coordinate_XY — Point
- Robot_Coordinate_Z — int
- Robot_Front_Coordinate_XY — Point
- Robot_Front_Coordinate_ZW — Point
- Time — Date
User
- User_Id — int — 기본 키 — NOT NULL
- Username — varchar(30)
- Password — varchar(255)
- Phone_Number — varchar(30)
- Email — varchar(30)
- Profile_Img — varchar(255)
- Is_Superuser — Boolean
- firebaseToken — varchar(255)
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_Coordinate_Info_Id — int — 외래 키 → Parking_Coordinate_Info.Parking_Coordinate_Info_Id — NOT NULL
- Parking_Area_Info_Id — int — 외래 키 → Parking_Coordinate_Info.Parking_Area_Info_Id — NOT NULL
- Charge_Time — int
- Is_Finished — Boolean
- Time — Date