self_storage

Tables (13)

order_storage_info (보류)

    orders (Untitled2)

    • id (Key) — Primary key — NOT NULL

    oreder_client_history (CopyOfUntitled2)

    • Field

    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

    site_category (지점카테고리)

      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