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