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