### EC-CUBE dtb_block_position Database Table Schema and Initial Data

Source: https://ec4.umebius.com/tables/dtb_block_position

This entry describes the `dtb_block_position` table, which is used to manage the placement of blocks within layouts in EC-CUBE. It includes column definitions, their attributes, and examples of initial data populated upon installation.

```APIDOC
dtb_block_position Table Schema:

| Column Name | Attribute (Doctrine) | Description |
|---|---|---|
| section | integer | |
| block_id | integer | |
| layout_id | integer | |
| block_row | integer | |
| block_id | integer | Foreign Key [dtb_block] |
| layout_id | integer | Foreign Key [dtb_layout] |

Initial Data (Example):

| section | block_id | layout_id | block_row | block_id (FK) | layout_id (FK) |
|---|---|---|---|---|---|
| 3 | 3 | 1 | 3 | 3 | 1 |
| 3 | 3 | 2 | 3 | 3 | 2 |
| 3 | 7 | 1 | 1 | 7 | 1 |
| 3 | 7 | 2 | 1 | 7 | 2 |
| 3 | 10 | 1 | 2 | 10 | 1 |
| 3 | 10 | 2 | 2 | 10 | 2 |
| 7 | 2 | 1 | 4 | 2 | 1 |
| 7 | 5 | 1 | 1 | 5 | 1 |
| 7 | 11 | 1 | 3 | 11 | 1 |
| 7 | 12 | 1 | 5 | 12 | 1 |
| 7 | 14 | 1 | 2 | 14 | 1 |
| 10 | 6 | 1 | 1 | 6 | 1 |
| 10 | 6 | 2 | 1 | 6 | 2 |
| 11 | 4 | 1 | 2 | 4 | 1 |
| 11 | 4 | 2 | 2 | 4 | 2 |
| 11 | 9 | 1 | 3 | 9 | 1 |
| 11 | 9 | 2 | 3 | 9 | 2 |
| 11 | 13 | 1 | 1 | 13 | 1 |
| 11 | 13 | 2 | 1 | 13 | 2 |
```

--------------------------------

### dtb_template Database Table Schema

Source: https://ec4.umebius.com/tables/dtb_template

Documents the schema for the `dtb_template` table, which stores information about shop templates in EC-CUBE. It includes details on column names, Doctrine data types, and descriptions, along with an example of initial data.

```APIDOC
dtb_template Table: ショップテンプレート一覧テーブル (Shop template list table)

Columns:
- id: integer (ID)
- template_code: string
- template_name: string
- create_date: datetimetz (データ登録日時 - Data registration date and time)
- update_date: datetimetz (データ更新日時 - Data update date and time)
- device_type_id: smallint (外部キー mtb_device_type - Foreign key to mtb_device_type)

Initial Data Example:
| id | template_code | template_name | create_date | update_date | device_type_id |
|---|---|---|---|---|---|
| 1 | default | デフォルト | 2017-03-07 10:14:52 | 2017-03-07 10:14:52 | 10 |
```

--------------------------------

### dtb_delivery_duration Table Schema and Initial Data

Source: https://ec4.umebius.com/tables/dtb_delivery_duration

Documents the `dtb_delivery_duration` database table, including its column definitions, data types (Doctrine attributes), descriptions, and initial default data after installation. This table stores information about various delivery durations.

```APIDOC
dtb_delivery_duration Table
Description: 配送に必要な日数の一覧テーブル (Table listing the number of days required for delivery)

Columns:
- id (integer): ID
- name (string): 名称 (Name)
- duration (smallint):
- sort_no (integer): 並び順 (Sort order)

Referenced Tables:
- dtb_product_class (via delivery_duration_id)

Initial Data (Installation Defaults):
- id: 1, name: 即日 (Same day), duration: 0, sort_no: 0
- id: 2, name: 1～2日後 (1-2 days later), duration: 1, sort_no: 1
- id: 3, name: 3～4日後 (3-4 days later), duration: 3, sort_no: 2
- id: 4, name: 1週間以降 (1 week or later), duration: 7, sort_no: 3
- id: 5, name: 2週間以降 (2 weeks or later), duration: 14, sort_no: 4
- id: 6, name: 3週間以降 (3 weeks or later), duration: 21, sort_no: 5
- id: 7, name: 1ヶ月以降 (1 month or later), duration: 30, sort_no: 6
- id: 8, name: 2ヶ月以降 (2 months or later), duration: 60, sort_no: 7
- id: 9, name: お取り寄せ(商品入荷後) (Backorder (after product arrival)), duration: 0, sort_no: 8
```

--------------------------------

### EC-CUBE dtb_block Database Table Schema and Initial Data

Source: https://ec4.umebius.com/tables/dtb_block

This entry documents the schema for the `dtb_block` table in EC-CUBE, which stores information about various content blocks used throughout the system. It includes column definitions with their data types and descriptions, as well as the initial default data populated upon installation.

```APIDOC
dtb_block Table Schema:

Description: Block list table.

Columns:
- id (integer): ID
- block_name (string): Block name
- file_name (string): File name
- use_controller (boolean): Indicates if a controller is used
- deletable (boolean): Indicates if the block is deletable
- create_date (datetimetz): Data registration date and time
- update_date (datetimetz): Data update date and time
- device_type_id (smallint): Foreign key to mtb_device_type

Referenced by:
- dtb_block_position (via block_id)

Initial Default Data:
- id: 1, block_name: カート (Cart), file_name: cart, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 2, block_name: カテゴリ (Category), file_name: category, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 3, block_name: カテゴリナビ(PC) (Category Nav PC), file_name: category_nav_pc, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 4, block_name: カテゴリナビ(SP) (Category Nav SP), file_name: category_nav_sp, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 5, block_name: 新入荷商品特集 (New Arrivals Eyecatch), file_name: eyecatch, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 6, block_name: フッター (Footer), file_name: footer, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 7, block_name: ヘッダー(商品検索・ログインナビ・カート) (Header - Product Search, Login Nav, Cart), file_name: header, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 8, block_name: ログインナビ(共通) (Login Nav - Common), file_name: login, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 9, block_name: ログインナビ(SP) (Login Nav - SP), file_name: login_sp, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 10, block_name: ロゴ (Logo), file_name: logo, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 11, block_name: 新着商品 (New Items), file_name: new_item, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 12, block_name: 新着情報 (News), file_name: news, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 13, block_name: 商品検索 (Product Search), file_name: search_product, use_controller: 1, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
- id: 14, block_name: トピック (Topic), file_name: topic, use_controller: 0, deletable: 0, create_date: 2017-03-07 10:14:52, update_date: 2017-03-07 10:14:52, device_type_id: 10
```

--------------------------------

### EC-CUBE dtb_tax_rule Table Schema

Source: https://ec4.umebius.com/tables/dtb_tax_rule

Defines the schema for the `dtb_tax_rule` table, which stores tax rate information. It includes details on columns, their data types (Doctrine attributes), descriptions, and foreign key relationships to other tables like `dtb_product_class`, `dtb_member`, `mtb_country`, `mtb_pref`, `dtb_product`, and `mtb_rounding_type`. An example of initial data is also provided.

```APIDOC
dtb_tax_rule

税率一覧テーブル

| カラム名 | 属性(Doctrine) | 説明 |
| --- | --- | --- |
| id | integer | ID |
| tax_rate | decimal | |
| tax_adjust | decimal | |
| apply_date | datetimetz | |
| create_date | datetimetz | データ登録日時 |
| update_date | datetimetz | データ更新日時 |
| product_class_id | integer | 外部キー [dtb_product_class](https://ec4.umebius.com/tables/dtb_product_class) |
| creator_id | integer | 外部キー [dtb_member](https://ec4.umebius.com/tables/dtb_member) |
| country_id | smallint | 外部キー [mtb_country](https://ec4.umebius.com/tables/mtb_country) |
| pref_id | smallint | 外部キー [mtb_pref](https://ec4.umebius.com/tables/mtb_pref) |
| product_id | integer | 外部キー [dtb_product](https://ec4.umebius.com/tables/dtb_product) |
| rounding_type_id | smallint | 外部キー [mtb_rounding_type](https://ec4.umebius.com/tables/mtb_rounding_type) |

## インストール直後の初期データ

| id | tax_rate | tax_adjust | apply_date | create_date | update_date | product_class_id | creator_id | country_id | pref_id | product_id | rounding_type_id |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| | | | | | | | | | | | |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 1 | 8 | 0 | 2017-03-07 10:14:52 | 2017-03-07 10:14:52 | 2017-03-07 10:14:52 | | | | | | 1 |
```

--------------------------------

### dtb_news Database Table Schema and Initial Data

Source: https://ec4.umebius.com/tables/dtb_news

This entry describes the `dtb_news` database table, which is used to manage news and announcements within the EC-CUBE platform. It includes detailed column definitions, their data types (Doctrine attributes), and a sample of the initial data populated upon installation. The table tracks news ID, publication date, title, description, URL, link method, creation/update timestamps, visibility, and the creator's ID.

```APIDOC
dtb_news Table Schema:

Description: Table for news list.

Columns:
- id: integer (ID)
- publish_date: datetimetz
- title: string
- description: text (Details)
- url: string
- link_method: boolean
- create_date: datetimetz (Data registration date)
- update_date: datetimetz (Data update date)
- visible: boolean (Display/Hide flag)
- creator_id: integer (Foreign key to dtb_member)

Initial Data (Example):
- id: 1
- publish_date: 2018-09-01 09:00:00
- title: Site opened!
- description: Delivering seasonal colorful sweets and exquisite gelato.
- url: 
- link_method: 1
- create_date: 2018-09-01 09:00:00
- update_date: 2018-09-01 09:00:00
- visible: 1
- creator_id: 
```

--------------------------------

### EC-CUBE `mtb_order_item_type` Database Table Schema

Source: https://ec4.umebius.com/tables/mtb_order_item_type

Defines the schema for the `mtb_order_item_type` table, which stores item types within orders. It includes details on columns, their Doctrine attributes, and initial data populated after installation. This table is referenced by `dtb_order_item`.

```APIDOC
Table: mtb_order_item_type
Description: 受注内の明細種別テーブル (Table for item types within orders)

Columns:
- id:
    Attribute: smallint (Doctrine)
    Description: ID
- name:
    Attribute: string (Doctrine)
    Description: 名称 (Name)
- sort_no:
    Attribute: smallint (Doctrine)
    Description: 並び順 (Sort order)

Referenced by:
- dtb_order_item (via order_item_type_id)

Initial Data (after installation):
| id | name       | sort_no |
|----|------------|---------|
| 1  | 商品       | 0       |
| 2  | 送料       | 1       |
| 3  | 手数料     | 2       |
| 4  | 割引       | 3       |
| 5  | 税         | 4       |
| 6  | ポイント   | 5       |
```

--------------------------------

### mtb_job Database Table Schema

Source: https://ec4.umebius.com/tables/mtb_job

Documents the `mtb_job` master table, which stores occupation data. It details the table's columns (ID, name, sort order), their Doctrine attributes, and how it's referenced by `dtb_customer` and `dtb_order` tables. The snippet also includes the initial default data populated upon installation.

```APIDOC
mtb_job:
  Description: Occupation master table
  Columns:
    - name: id
      type: smallint (Doctrine)
      description: ID
    - name: name
      type: string (Doctrine)
      description: Name
    - name: sort_no
      type: smallint (Doctrine)
      description: Sort Order
  Referenced by:
    - dtb_customer (job_id)
    - dtb_order (job_id)
  Initial Data:
    - id: 1
      name: 公務員
      sort_no: 0
    - id: 2
      name: コンサルタント
      sort_no: 1
    - id: 3
      name: コンピューター関連技術職
      sort_no: 2
    - id: 4
      name: コンピューター関連以外の技術職
      sort_no: 3
    - id: 5
      name: 金融関係
      sort_no: 4
    - id: 6
      name: 医師
      sort_no: 5
    - id: 7
      name: 弁護士
      sort_no: 6
    - id: 8
      name: 総務・人事・事務
      sort_no: 7
    - id: 9
      name: 営業・販売
      sort_no: 8
    - id: 10
      name: 研究・開発
      sort_no: 9
    - id: 11
      name: 広報・宣伝
      sort_no: 10
    - id: 12
      name: 企画・マーケティング
      sort_no: 11
    - id: 13
      name: デザイン関係
      sort_no: 12
    - id: 14
      name: 会社経営・役員
      sort_no: 13
    - id: 15
      name: 出版・マスコミ関係
      sort_no: 14
    - id: 16
      name: 学生・フリーター
      sort_no: 15
    - id: 17
      name: 主婦
      sort_no: 16
    - id: 18
      name: その他
      sort_no: 17
```

--------------------------------

### 商品CSVアップロードフォーマット仕様

Source: https://ec4.umebius.com/screens/admin_product_csv_import

EC-CUBEシステムで商品の一括登録および更新に使用されるCSVファイルの必須フォーマットとフィールドを定義します。各列のフィールド名、データ型、および制約が含まれます。

```APIDOC
CSVファイルフォーマット:

- 雛形ファイルダウンロードボタン: ボタンを押すと雛形のCSVファイルをダウンロードする
- 商品ID: 新規登録の場合は空にしてください。既存の商品を更新する場合は、商品IDを指定してください。
- 公開ステータス(ID):
- 商品名:
- ショップ用メモ欄:
- 商品説明(一覧):
- 商品説明(詳細):
- 検索ワード:
- フリーエリア:
- 商品削除フラグ: 0:登録 1:削除を指定します。未指定の場合、0として扱います。
- 商品画像: 画像のファイル名を指定します。複数画像の場合、画像ファイル名をカンマ区切りで「"」で囲んでください。
- 商品カテゴリ(ID): カテゴリIDを指定します。複数カテゴリの場合、商品カテゴリIDをカンマ区切りで「"」で囲んでください。
- タグ(ID): タグIDを指定します。複数タグの場合、タグIDをカンマ区切りで「"」で囲んでください。
- 販売種別(ID):
- 規格分類1(ID):
- 規格分類2(ID):
- 発送日目安(ID):
- 商品コード:
- 在庫数: 在庫数無制限フラグが0の場合、0以上の数値を設定してください。
- 在庫数無制限フラグ: 0:制限 1: 無制限を指定します。
- 販売制限数: 1以上の数値を設定
- 通常価格: 0以上の数値を設定
- 販売価格: 0以上の数値を設定
- 送料: 商品ごとの送料設定が有効の場合、0以上の数値を設定
- 税率: 商品別税率機能設定が有効の場合、0以上の数値を設定
```

--------------------------------

### Member Management Actions and Associated Data Displays

Source: https://ec4.umebius.com/screens/admin_customer

This section outlines general actions available on the member management screen, along with details on managing delivery addresses and viewing order history for registered members.

```APIDOC
## 全体 - General Actions
| Action/Field | Description |
|---|---|
| 会員一覧リンク (Member List Link) | Clicking this link discards input and navigates to the member list screen. |
| 会員種別 (Member Type) | Select from Provisional Member, Full Member, or Withdrawn. |
| 登録ボタン (Register Button) | Pressing this button registers the entered content. |

## お届け先住所（登録会員のみ表示） - Delivery Address (Only for Registered Members)
| Field Name/Action | Description |
|---|---|
| お名前 (Name) | Displays the name of the delivery recipient. |
| 住所 (Address) | Displays the delivery address. |
| 電話番号 (Phone Number) | Displays the delivery recipient's phone number. |
| 削除ボタン (Delete Button) | Pressing this button displays a deletion confirmation pop-up. Pressing the delete button in the pop-up deletes the delivery address. Pressing the cancel button reverts the action. |
| お届け先住所を追加ボタン (Add Delivery Address Button) | Pressing this button navigates to the delivery address registration screen. |

## 注文履歴（登録会員のみ表示） - Order History (Only for Registered Members)
| Field Name | Description |
|---|---|
| 注文日 (Order Date) | Displays the order year, month, day, hour, and minute. |
| 注文番号 (Order Number) | Displays the order management number. |
| 購入金額 (Purchase Amount) | Displays the purchase amount. |
| 対応状況 (Status) | Displays the order processing status. |
```

--------------------------------

### Member Data Fields for Registration and Editing

Source: https://ec4.umebius.com/screens/admin_customer

This section details the data fields used for both new member registration and editing existing member profiles within the system. It specifies field names, their purpose, and any special behaviors like auto-completion or editability.

```APIDOC
## 会員情報（新規） - New Member Information
| Field Name | Description |
|---|---|
| お名前 (Name) | Enter the member's first and last name. |
| お名前(カナ) (Name Katakana) | Enter the member's first and last name in Katakana. |
| 会社名 (Company Name) | Enter the company name the member belongs to. |
| 住所 (Address) | Entering a 7-digit postal code automatically fills in the city/town. |
| メールアドレス (Email Address) | Enter the email address for receiving communications. |
| 電話番号 (Phone Number) | Enter the phone number. |
| パスワード (Password) | Enter the password. |
| パスワード(確認用) (Password (Confirmation)) | Re-enter the password. |
| 性別 (Gender) | Select either Male or Female. |
| 職業 (Occupation) | Select an occupation from the options. |
| 誕生日 (Birthday) | Enter the date of birth. |
| ポイント (Points) | (No description provided) |

## 会員情報（会員一覧から遷移） - Member Information (from Member List)
| Field Name | Description |
|---|---|
| 会員ID (Member ID) | The assigned member number. Not editable. |
| お名前 (Name) | Enter the member's first and last name. Editable. |
| お名前(カナ) (Name Katakana) | Enter the member's first and last name in Katakana. Editable. |
| 会社名 (Company Name) | Enter the company name the member belongs to. Editable. |
| 住所 (Address) | Entering a 7-digit postal code automatically fills in the city/town. Editable. |
| メールアドレス (Email Address) | Enter the email address for receiving communications. Editable. |
| 電話番号 (Phone Number) | Enter the phone number. Editable. |
| パスワード (Password) | Enter the password. Editable. |
| パスワード(確認用) (Password (Confirmation)) | Re-enter the password. Editable. |
| 性別 (Gender) | Select either Male or Female. Re-selectable. |
| 職業 (Occupation) | Select an occupation from the options. Re-selectable. |
| 誕生日 (Birthday) | Enter the date of birth. |
| ポイント (Points) | (No description provided) |

## ショップ用メモ欄 - Shop Memo Field
| Field Name | Description |
|---|---|
| ショップ用メモ欄 (Shop Memo Field) | For shop staff to enter supplementary information about the member. |
```

--------------------------------

### EC-CUBE dtb_delivery Database Table Schema

Source: https://ec4.umebius.com/tables/dtb_delivery

Detailed schema definition for the `dtb_delivery` table, which manages delivery methods in EC-CUBE. It includes column names, Doctrine attributes, descriptions, and references to other related tables like `dtb_delivery_fee`, `dtb_delivery_time`, `dtb_payment_option`, and `dtb_shipping`.

```APIDOC
dtb_delivery Table Schema:

Description: 配送方法の一覧テーブル (List table for delivery methods)

Columns:
- id (integer): ID
- name (string): 名称 (Name)
- service_name (string):
- description (string): 詳細 (Details)
- confirm_url (string):
- sort_no (integer): 並び順 (Sort order)
- visible (boolean): 表示/非表示フラグ (Visible/Hidden flag)
- create_date (datetimetz): データ登録日時 (Data registration date/time)
- update_date (datetimetz): データ更新日時 (Data update date/time)
- creator_id (integer): 外部キー dtb_member (Foreign key to dtb_member)
- sale_type_id (smallint): 外部キー mtb_sale_type (Foreign key to mtb_sale_type)

Referenced Tables:
- dtb_delivery_fee: delivery_id
- dtb_delivery_time: delivery_id
- dtb_payment_option: delivery_id
- dtb_shipping: delivery_id

Initial Data Example:
| id | name | service_name | description | confirm_url | sort_no | visible | create_date | update_date | creator_id | sale_type_id |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | サンプル業者 | サンプル業者 | | | 1 | 1 | 2017-03-07 10:14:52 | 2017-03-07 10:14:52 | | 1 |
| 2 | サンプル宅配 | サンプル宅配 | | | 2 | 1 | 2017-03-07 10:14:52 | 2017-03-07 10:14:52 | | 2 |
```

--------------------------------

### dtb_layout Database Table Schema

Source: https://ec4.umebius.com/tables/dtb_layout

Defines the structure and initial data for the `dtb_layout` table, which stores layout configurations in EC-CUBE. It includes column definitions, data types, descriptions, and references to other tables.

```APIDOC
dtb_layout Table Schema:

| Column Name | Attribute (Doctrine) | Description |
|---|---|---|
| id | integer | ID |
| layout_name | string | Layout Name |
| create_date | datetimetz | Data Registration Date and Time |
| update_date | datetimetz | Data Update Date and Time |
| device_type_id | smallint | Foreign Key to mtb_device_type |

Referenced by:
- dtb_block_position: layout_id
- dtb_page_layout: layout_id

Initial Data Examples:
| id | layout_name | create_date | update_date | device_type_id |
|---|---|---|---|---|
| 0 | プレビュー用レイアウト (Layout for Preview) | 2017-03-07 10:14:52 | 2017-03-07 10:14:52 | 10 |
| 1 | トップページ用レイアウト (Layout for Top Page) | 2017-03-07 10:14:52 | 2017-03-07 10:14:52 | 10 |
| 2 | 下層ページ用レイアウト (Layout for Lower Pages) | 2017-03-07 10:14:52 | 2017-03-07 10:14:52 | 10 |
```

--------------------------------

### mtb_product_status Database Table Definition

Source: https://ec4.umebius.com/tables/mtb_product_status

Defines the schema, relationships, and initial data for the `mtb_product_status` table, which stores product status information in EC-CUBE. This table is referenced by `dtb_product`.

```APIDOC
# mtb_product_status

商品ステータスの一覧テーブル

## Columns

| カラム名 | 属性(Doctrine) | 説明 |
| --- | --- | --- |
| id | smallint | ID |
| name | string | 名称 |
| sort_no | smallint | 並び順 |

## Referenced Tables

- dtb_product: product_status_id

## Initial Data (after installation)

| id | name | sort_no |
| --- | --- | --- |
| 1 | 公開 | 0 |
| 2 | 非公開 | 1 |
| 3 | 廃止 | 2 |
```

--------------------------------

### Database Table Schema: dtb_customer_favorite_product

Source: https://ec4.umebius.com/tables/dtb_customer_favorite_product

Defines the schema for the `dtb_customer_favorite_product` table, which stores information about products favorited by customers. It includes columns for unique identification, timestamps, and foreign keys linking to customer and product tables.

```APIDOC
Table Name: dtb_customer_favorite_product
Description: 会員がお気に入りに登録した商品テーブル (Table for products favorited by members)

Columns:
- id (integer): ID
- create_date (datetimetz): データ登録日時 (Data registration timestamp)
- update_date (datetimetz): データ更新日時 (Data update timestamp)
- customer_id (integer): 外部キー [dtb_customer] (Foreign key to dtb_customer table)
- product_id (integer): 外部キー [dtb_product] (Foreign key to dtb_product table)
```

--------------------------------

### dtb_cart Database Table Schema

Source: https://ec4.umebius.com/tables/dtb_cart

Defines the schema for the `dtb_cart` table, which stores shopping cart information including customer details, total price, delivery fees, and timestamps. It also indicates its relationship with the `dtb_cart_item` table.

```APIDOC
dtb_cart Table Schema:

Columns:
- id (integer): ID
- cart_key (string):
- customer_id (integer): Foreign key to dtb_customer
- pre_order_id (string):
- total_price (decimal):
- delivery_fee_total (decimal):
- sort_no (smallint): Sort order
- create_date (datetimetz): Data registration timestamp
- update_date (datetimetz): Data update timestamp
- add_point (decimal): Added points
- use_point (decimal): Used points

Referenced by:
- dtb_cart_item (via cart_id)
```

--------------------------------

### Eccube Core Entity Data Model

Source: https://ec4.umebius.com/tables/dtb_csv

Detailed schema definitions for the `Eccube\Entity\Shipping`, `Eccube\Entity\Order`, and `Eccube\Entity\OrderItem` classes, including property names, their Japanese and English descriptions, and inferred data types. This provides a comprehensive overview of the data structure used in Eccube for shipping, order, and order item management.

```APIDOC
Eccube\\Entity\\Shipping:
  shipping_delivery_fee:
    description: 送料 (Shipping fee)
    type: float
  shipping_date:
    description: 発送日 (Shipping date)
    type: datetime
  tracking_number:
    description: 出荷伝票番号 (Tracking number)
    type: string
  note:
    description: 配達用メモ (Delivery memo)
    type: string
  mail_send_date:
    description: 出荷メール送信日 (Shipping email send date)
    type: datetime

Eccube\\Entity\\Order:
  id:
    description: 注文ID (Order ID)
    type: integer
  order_no:
    description: 注文番号 (Order number)
    type: string
  Customer.id:
    description: 会員ID (Customer ID)
    type: integer
  name01:
    description: お名前(姓) (First name - surname)
    type: string
  name02:
    description: お名前(名) (First name - given name)
    type: string
  kana01:
    description: お名前(セイ) (First name - surname, kana)
    type: string
  kana02:
    description: お名前(メイ) (First name - given name, kana)
    type: string
  company_name:
    description: 会社名 (Company name)
    type: string
  postal_code:
    description: 郵便番号 (Postal code)
    type: string
  Pref.id:
    description: 都道府県(ID) (Prefecture ID)
    type: integer
  Pref.name:
    description: 都道府県(名称) (Prefecture name)
    type: string
  addr01:
    description: 住所1 (Address 1)
    type: string
  addr02:
    description: 住所2 (Address 2)
    type: string
  email:
    description: メールアドレス (Email address)
    type: string
  phone_number:
    description: TEL (Phone number)
    type: string
  Sex.id:
    description: 性別(ID) (Gender ID)
    type: integer
  Sex.name:
    description: 性別(名称) (Gender name)
    type: string
  Job.id:
    description: 職業(ID) (Occupation ID)
    type: integer
  Job.name:
    description: 職業(名称) (Occupation name)
    type: string
  birth:
    description: 誕生日 (Birthday)
    type: date
  note:
    description: ショップ用メモ欄 (Shop memo field)
    type: string
  subtotal:
    description: 小計 (Subtotal)
    type: float
  discount:
    description: 値引き (Discount)
    type: float
  delivery_fee_total:
    description: 送料 (Total shipping fee)
    type: float
  tax:
    description: 税金 (Tax)
    type: float
  total:
    description: 合計 (Total)
    type: float
  payment_total:
    description: 支払合計 (Payment total)
    type: float
  OrderStatus.id:
    description: 対応状況(ID) (Order status ID)
    type: integer
  OrderStatus.name:
    description: 対応状況(名称) (Order status name)
    type: string
  Payment.id:
    description: 支払方法(ID) (Payment method ID)
    type: integer
  payment_method:
    description: 支払方法(名称) (Payment method name)
    type: string
  order_date:
    description: 受注日 (Order date)
    type: datetime
  payment_date:
    description: 入金日 (Payment date)
    type: datetime

Eccube\\Entity\\OrderItem:
  id:
    description: 注文詳細ID (Order item ID)
    type: integer
  Product.id:
    description: 商品ID (Product ID)
    type: integer
  ProductClass.id:
    description: 商品規格ID (Product class ID)
    type: integer
  product_name:
    description: 商品名 (Product name)
    type: string
  product_code:
    description: 商品コード (Product code)
    type: string
```

--------------------------------

### Eccube OrderItem Entity Fields

Source: https://ec4.umebius.com/tables/dtb_csv

Describes the data fields for individual items within an Eccube order, covering product details, quantities, pricing, and tax information.

```APIDOC
Eccube\Entity\OrderItem Fields:
  id: 注文詳細ID (Unique identifier for the order item)
  Product.id: 商品ID (ID of the associated product)
  ProductClass.id: 商品規格ID (ID of the product class/variant)
  product_name: 商品名 (Name of the product)
  product_code: 商品コード (Product code/SKU)
  class_name1: 規格名1 (Specification name 1 for the product variant)
  class_name2: 規格名2 (Specification name 2 for the product variant)
  class_category_name1: 規格分類名1 (Specification category name 1 for the product variant)
  class_category_name2: 規格分類名2 (Specification category name 2 for the product variant)
  price: 価格 (Unit price of the item)
  quantity: 個数 (Quantity of the item)
  tax_rate: 税率 (Applicable tax rate for the item)
  tax_rule: 税率ルール(ID) (ID of the tax rule applied)
  OrderItemType.id: 明細区分(ID) (ID of the order item type)
  OrderItemType.name: 明細区分(名称) (Name of the order item type)
```

--------------------------------

### Eccube Category Entity Properties

Source: https://ec4.umebius.com/tables/dtb_csv

Defines the properties for product categories in the Eccube system, including ID, display order, name, parent category, and hierarchy level. This entity is used to organize products within the e-commerce catalog.

```APIDOC
Eccube\Entity\Category:
  id: カテゴリID
  sort_no: 表示ランク
  name: カテゴリ名
  Parent.id: 親カテゴリID
  level: 階層
```

--------------------------------

### EC-CUBE `mtb_sex` Master Table Definition

Source: https://ec4.umebius.com/tables/mtb_sex

Defines the schema, relationships, and initial data for the `mtb_sex` (gender master) table used in EC-CUBE. This table stores gender information and is referenced by customer and order data, providing a standardized way to manage gender-related attributes.

```APIDOC
# mtb_sex

性別マスタテーブル (Gender Master Table)

## Columns:
| Column Name | Attribute (Doctrine) | Description |
| --- | --- | --- |
| id | smallint | ID |
| name | string | 名称 (Name) |
| sort_no | smallint | 並び順 (Sort Order) |

## Referenced Tables:
- dtb_customer :sex_id
- dtb_order :sex_id

## Initial Data (Post-Installation):
| id | name | sort_no |
| --- | --- | --- |
| 1 | 男性 (Male) | 0 |
| 2 | 女性 (Female) | 1 |
```

--------------------------------

### Eccube Order Entity Fields

Source: https://ec4.umebius.com/tables/dtb_csv

Defines the data fields associated with the Eccube Order entity, including total amounts, payment details, order status, and dates.

```APIDOC
Eccube\Entity\Order Fields:
  total: 合計 (Total amount of the order)
  payment_total: 支払合計 (Total amount paid for the order)
  OrderStatus.id: 対応状況(ID) (ID of the order status)
  OrderStatus.name: 対応状況(名称) (Name of the order status)
  Payment.id: 支払方法(ID) (ID of the payment method)
  payment_method: 支払方法(名称) (Name of the payment method)
  order_date: 受注日 (Date the order was placed)
  payment_date: 入金日 (Date the payment was received)
```