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)