test

Tables (7)

CUSTOMER_TB

  • car_id — varchar(14) — Primary key — NOT NULL
  • pw — varchar(20)
  • card_num — varchar(20)
  • Field — VARCHAR(255)

FLOOR_STATE_TB

  • floor — PK(INT) — Primary key — NOT NULL
  • seq — PK(INT) — Foreign key → PL_LIST_TB.seq — NOT NULL
  • num_space — INT
  • num_park_space — INT
  • num_parked — INT

PL_INFO_TB

  • seq — PK(INT) — Foreign key → PL_LIST_TB.seq — NOT NULL
  • Field — VARCHAR(40)
  • num_floors — INT
  • total_num_park_space — INT
  • cur_num_park_space — INT
  • fee — INT

PL_LIST_TB

  • seq — PK(INT) — Primary key — NOT NULL
  • nm_park — VARCHAR(40)
  • city — VARCHAR(20)
  • gu — VARCHAR(20)
  • dong — VARCHAR(20)
  • nm_doro — VARCHAR(80)
  • num_park — pk
  • char — NULL

PL_MEMBER_TB

  • id — VARCHAR(40) — Primary key — NOT NULL
  • seq — PK(INT) — Foreign key → PL_INFO_TB.seq — NOT NULL
  • join_date — VARCHAR(255)
  • withdrawal_date — VARCHAR(255)
  • card_num — VARCHAR(20)
  • car_id — VARCHAR(14)
  • Field — VARCHAR(255)

PL_STATE_TB

  • num_space — PK(CHAR(6)) — Primary key — NOT NULL
  • floor — PK(INT) — Foreign key → FLOOR_STATE_TB.floor — NOT NULL
  • seq — PK(INT) — Foreign key → FLOOR_STATE_TB.seq — NOT NULL
  • nm_park — VARCHAR(40)
  • status — INT

RESERVED_TB

  • rev_num — PK(INT) — Primary key — NOT NULL
  • num_space — PK(CHAR(6)) — Foreign key → PL_STATE_TB.num_space — NOT NULL
  • floor — PK(INT) — Foreign key → PL_STATE_TB.floor — NOT NULL
  • seq — INT — NOT NULL
  • receiving_time — DATE
  • forwarding_time — DATE
  • fee — INT
  • Field2 — VARCHAR(255)