girigiri-back
Tables (7)
equipment
- id — bigint — Primary key
- category — varchar(15) — NOT NULL
- components — varchar(100)
- description — varchar(100)
- img_url — varchar(255) — NOT NULL
- maker — varchar(20) — NOT NULL
- max_rental_days — integer — NOT NULL
- model_name — varchar(50) — NOT NULL
- purpose — varchar(100)
- rental_place — varchar(20) — NOT NULL
- total_quantity — integer — NOT NULL
inventory
- id — bigint — Primary key
- amount — integer — NOT NULL
- rental_end_date — date — NOT NULL
- rental_start_date — date — NOT NULL
- equipment_id — bigint — Foreign key → equipment.id
- member_id (id2) — bigint — Foreign key → member.id
item
- id — bigint — Primary key
- available — boolean — NOT NULL
- property_number — varchar(20) — NOT NULL
- equipment_id — bigint — Foreign key → equipment.id
member
- id — bigint — Primary key
- birth_date — varchar(10) — NOT NULL
- email — varchar(30) — NOT NULL
- member_number — varchar(15) — NOT NULL
- name — varchar(10) — NOT NULL
- password — varchar(255) — NOT NULL
- phone_number — varchar(15) — NOT NULL
- role — varchar(10)
rental_spec
- id — bigint — Primary key
- accept_date_time — timestamp(6)
- property_number — varchar(20) — NOT NULL
- return_date_time — timestamp(6)
- status — varchar(20) — NOT NULL
- reservation_id — bigint — Foreign key → reservation.id
- id (reservation_spec_id) — bigint — Foreign key → reservation_spec.id
reservation
- id — bigint — Primary key
- accept_date_time — timestamp(6)
- email — varchar(30) — NOT NULL
- name — varchar(10) — NOT NULL
- phone_number — varchar(15) — NOT NULL
- purpose — varchar(50) — NOT NULL
- terminated — boolean — NOT NULL
- member_id — bigint — Foreign key → member.id
reservation_spec
- id — bigint — Primary key
- amount — integer — NOT NULL
- rental_end_date — date — NOT NULL
- rental_start_date — date — NOT NULL
- status — varchar(20) — NOT NULL
- equipment_id (id2) — bigint — Foreign key → equipment.id
- reservation_id (id3) — bigint — Foreign key → reservation.id