Agent: Document Agent
<aside> <img src="notion://custom_emoji/be6005d7-8302-4c8e-93fe-03d0d3d71970/12f3c107-d7a8-8009-8054-007a9b09b0b8" alt="notion://custom_emoji/be6005d7-8302-4c8e-93fe-03d0d3d71970/12f3c107-d7a8-8009-8054-007a9b09b0b8" width="40px" />
Design the table using the @Member Information Update Screen Specifications screen design as a reference, and output it according to the @Table Definition Template format.
</aside>
## Table Information
| Logical Name | Physical Name | Type | Description/Remarks |
| ------------ | ------------- | ---------- | ------------------- |
| \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ |
## Column Information
| No. | Logical Name | Physical Name | Data Type | Length/Precision | Scale | Required | Primary Key | Default Value | Foreign Key | Index | Definition |
| --- | ------------ | ------------- | ---------- | ---------------- | ---------- | ---------- | ----------- | ------------- | ----------- | ---------- | ---------- |
| 1 | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ |
| 2 | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ |
| 3 | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ |
| 4 | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ |
| 5 | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ |
## Index Information
| Index Name | Target Column | Index Type | Unique Constraint |
| ---------- | ------------- | ---------- | ----------------- |
| \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ |
## Foreign Key Constraints
| Constraint Name | Source Column | Referenced Table.Column |
| --------------- | ------------- | ----------------------- |
| \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ | \\_\\_\\_\\_\\_ |
## Item Descriptions
- **System Name**: The name of the system identified from the source code. Extracted from comments or project names.
- **Logical Name**: The business name inferred from comments or labels in the source code. Often uses Japanese names.
- **Physical Name**: The actual table or column name in the database. Usually in English, following naming conventions such as uppercase/lowercase or snake\\_case.
- **Type**: The type of table. Determined from the actual database implementation and usage (table, view, temporary table, etc.).
- **Description/Remarks**: Notes on the table's purpose or special considerations.
- **No.**: The identifier number of the column. Usually follows the definition order in the database.
- **Data Type**: The type information defined in the database. Includes DBMS-specific types.
- **Length/Precision**: The length or precision constraints set for the data type. For example, NVARCHAR(50) would be "50".
- **Scale**: The number of decimal places for numeric types. For example, DECIMAL(10,2), "2" is recorded here.
- **Required**: "Y" for columns that do not allow NULL, "N" for columns that allow NULL. Determined by database constraints.
- **Primary Key**: "Y" for columns set as primary key, otherwise blank or "N".
- **Default Value**: The default value set for the column.
- **Foreign Key**: If there is a foreign key constraint, record the referenced table and column name.
- **Index**: "Y" if an index is set, "N" if not.
- **Definition**: The purpose and possible values of the column inferred from comments or data samples in the code. For example, "Status Code (0: Unprocessed, 1: Processing, 2: Completed, 9: Error)"—clearly state possible values and their meanings. Also record display format or input restrictions if they can be inferred.
- **Index Name**: The name of the index defined in the database.
- **Target Column**: The column name(s) targeted by the index. For composite indexes, also record the order of columns.
- **Index Type**: The type of index (BTREE, HASH, etc.).
- **Unique Constraint**: "Y" for unique indexes, "N" otherwise.
- **Constraint Name**: The name of the foreign key constraint.
- **Source Column**: The column name that is the source of the foreign key constraint.
- **Referenced Table.Column**: The table and column name that is the target of the foreign key constraint.
## Table Information
| Logical Name | Physical Name | Type | Description/Remarks |
| ------------ | ------------- | ----- | --------------------------------------- |
| Member | members | Table | Table to store basic member information |
## Column Information
| No. | Logical Name | Physical Name | Data Type | Length/Size | Precision | Required | Primary Key | Default Value | Foreign Key | Index | Definition |
| --- | ----------------- | -------------- | --------- | ----------- | --------- | -------- | ----------- | ------------------ | ----------- | ---------- | ---------------------------------- |
| 1 | Member ID | id | BIGINT | 20 | | Y | Y | Auto-increment | | Y | Unique identifier for each member |
| 2 | Email Address | email | VARCHAR | 255 | | Y | | | | Y (UNIQUE) | Unique, email format required |
| 3 | Password | password | VARCHAR | 255 | | Y | | | | N | Encrypted password |
| 4 | Profile Image URL | profile\\_image | VARCHAR | 500 | | N | | | | N | URL of member's profile image file |
| 5 | Created At | created\\_at | DATETIME | | | Y | | CURRENT\\_TIMESTAMP | | N | Record creation timestamp |
| 6 | Updated At | updated\\_at | DATETIME | | | Y | | CURRENT\\_TIMESTAMP | | N | Record update timestamp |
## Index Information
| Index Name | Target Column | Index Type | Unique Constraint |
| ------------------- | ------------- | ---------- | ----------------- |
| idx\\_members\\_email | email | BTREE | Y |
## Foreign Key Constraints
| Constraint Name | Source Column | Target Table.Column |
| --------------- | ------------- | ------------------- |
| None | | |
## Item Description
- **Member ID (id)**: Unique identifier for each member. Primary key. Auto-increment.
- **Email Address (email)**: Registered email address. Unique constraint, required. Format check and uniqueness validation on change.
- **Password (password)**: Encrypted password. Required. Minimum 8 characters, must include symbols for strength.
- **Profile Image (profile\\_image)**: Storage URL for image file. Limited to jpg/png, max size 2MB.
- **Created At (created\\_at)**: Record creation timestamp. Set automatically.
- **Updated At (updated\\_at)**: Record update timestamp. Automatically updated on each change.
(Based on the screen specifications of @document, required fields and validations have been systematically considered in the design. The format follows @document. This table information can be referenced for future API integration and screen validation implementation.) Sources: [/ユーザガイド/テーブル定義書テンプレート２](<https://studio.jitera.app/projects/6140f2cb-6f83-4e8e-a6a5-f774e7779871-fc9e01/docs/b8a5c943-8813-4c48-9198-827b5778b7a7>)