self_storage
Tables (13)
orders (Untitled2)
- id (Key) — Primary key — NOT NULL
oreder_client_history (CopyOfUntitled2)
overdue_payment (이용료 미납금)
- id (Key) — Primary key — NOT NULL
- order_id (Key2) — Foreign key → storage_order.id — NOT NULL
payment_type (결제 방식)
- id (Key) — Primary key — NOT NULL
site (지점)
- id (Key) — Primary key — NOT NULL
site_bundle_detail (지점 보관함 상세 정보)
- id (Key) — Primary key — NOT NULL
- site_id (Key2) — Foreign key → site.id — NOT NULL
- type_id (Key3) — Foreign key → storage_bundle_type.id — NOT NULL
storage (스토리지)
- id (Key) — Primary key — NOT NULL
- site_id (Key2) — Foreign key → site.id — NOT NULL
- type_id (Key3) — Foreign key → storage_bundle_type.id — NOT NULL
storage_bundle_type (스토리지 번들 타입)
- id (Key) — Primary key — NOT NULL
storage_order (스토리지 주문 정보)
- id (Key) — Primary key — NOT NULL
- order_id (Key2) — Foreign key → orders.id — NOT NULL
- user_id (Key3) — Foreign key → user.id — NOT NULL
- site_id (Key4) — Foreign key → site.id — NOT NULL
- payment_id (Key5) — Foreign key → payment_type.id — NOT NULL
- Field
storage_order_payment_log (스토리지 주문 결제 내역)
- id (Key) — Primary key — NOT NULL
- order_Id (Key2) — Foreign key → storage_order.id — NOT NULL
user (CopyOfUntitled22)
- id (Key) — Primary key — NOT NULL