parking
Tables (4)
Car (자동차)
- c_num (Key) — varchar(30) — Primary key — NOT NULL
- c_color (Field) — varchar(30)
- c_model (Field2) — varchar(30)
- c_id_code (Field3) — varchar(30)
- id (Key2) — varchar(30) — Foreign key → User.id_code — NOT NULL
Reservation (예약)
- r_code (Key) — varchar(30) — Primary key — NOT NULL
- r_place (Field) — varchar(30)
- r_id_code (Field2) — varchar(30)
- id_code (Key2) — varchar(30) — Foreign key → User.id_code — NOT NULL
Time (시간)
- t_num (Key) — int — Primary key — NOT NULL
- t_in_time (Field) — varchar(30)
- t_out_time (Field2) — varchar(30)
- t_id_code (Field3) — varchar(30)
- id_code (Key2) — varchar(30) — Foreign key → User.id_code — NOT NULL
User (사용자)
- id_code (Key) — varchar(30) — Primary key — NOT NULL
- id_unuser_code (Field) — varchar(30)