preprint

Tables (10)

locker_lental

  • id (Key3) — int — Primary key — NOT NULL
  • user_id (Key) — users — Foreign key → users.id — NOT NULL
  • locker_id (Key2) — lockers — Foreign key → lockers.id — NOT NULL
  • rental_start_date (Field) — DATETIME
  • rental_end_date (Field2) — DATETIME
  • rental_period (Field3) — int
  • status (Field4) — String

locker_lental_payment

  • id (Key) — int — Primary key — NOT NULL
  • locker_lental_id (Key3) — int — Foreign key → locker_lental.id — NOT NULL
  • uid (Field) — UUIDField
  • pay_method (Field2) — CharField
  • pay_status (Field3) — CharField
  • amount (Field4) — int
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME

lockers

  • id (Key) — int — Primary key — NOT NULL
  • locker_number (Field) — int
  • status (Field2) — String

order_payment

  • id (Key) — int — Primary key — NOT NULL
  • order_id (Key2) — int — Foreign key → orders.id — NOT NULL
  • uid (Field) — UUIDField
  • pay_method (Field2) — CharField
  • pay_status (Field3) — CharField
  • amount (Field4) — int
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME

ordered_files

  • id (Key) — int — Primary key — NOT NULL
  • order_id (Key2) — int — Foreign key → orders.id — NOT NULL
  • order_file (Field) — FileField

orders

  • id (Key) — int — Primary key — NOT NULL
  • order_user (Key2) — int — Foreign key → users.id — NOT NULL
  • order_price (Field) — varchar(100)
  • order_pw (Field2) — varchar(100)
  • order_color (Field3) — varchar(100)
  • order_date (Field4) — DATETIME
  • locker_number (Field5) — int
  • status (Field6) — String
  • total_pages (Field7) — int

pass_order (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • pass_order_user (Key2) — int — Foreign key → users.id — NOT NULL
  • pass_order_price (Field3) — varchar(100)
  • pass_order_pin_number (Field4) — String
  • pass_order_color (Field5) — String
  • pass_order_date (Field6) — DATETIME
  • status (Field7) — String
  • total_pages (Field8) — int
  • is_takeout (Field) — boolean

pass_order_payment (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • pass_order_id (Key2) — int — Foreign key → pass_order.id — NOT NULL
  • uid (Field) — UUIDField
  • pay_method (Field2) — CharField
  • pay_status (Field3) — CharField
  • amount (Field4) — int
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME

pass_ordered_files (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • pass_order_id (Key2) — int — Foreign key → pass_order.id — NOT NULL
  • pass_order_file (Field2) — FileField

users

  • id (Key) — int — Primary key — NOT NULL
  • pw (Field4) — varchar(100)
  • name (Field) — varchar(100)
  • email (Field2) — varchar(100)
  • phone (Field3) — varchar(100)
  • created_at (Field5) — DATETIME
  • email_opt_in (Field6) — BOOLEAN