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)