Autumn product update

Sample values and generated SQL are preserved exactly as exported, including Japanese data.

日本語English

A report for reviewing project edits. It does not apply changes to a database.

SQL target database: MySQL

Colors: added = green, changed = yellow, deleted = red

PRODUCT

Column changes & definitions (8 columns)
ColumnAt the start of editingCurrent master dataProject edits
Code (code)Code (code) Type: string Length/precision: 3 Required: yes Default: noneCode (code) Type: string Length/precision: 3 Required: yes Default: noneCode (code) Type: string Length/precision: 3 Required: yes Default: none
Product name (name)Product name (name) Type: string Length/precision: 100 Required: no Default: noneProduct name (name) Type: string Length/precision: 100 Required: no Default: noneProduct name (name) Type: string Length/precision: 100 Required: no Default: none
Price (price)Price (price) Type: number Length/precision: 10 Decimal places: 2 Required: no Default: nonePrice (price) Type: number Length/precision: 10 Decimal places: 2 Required: no Default: nonePrice (price) Type: number Length/precision: 10 Decimal places: 2 Required: no Default: none
Note (memo)Note (memo) Type: long text Required: no Default: noneNote (memo) Type: long text Required: no Default: noneNote (memo) Type: long text Required: no Default: none
Settings (setting)Settings (setting) Type: JSON Required: no Default: noneSettings (setting) Type: JSON Required: no Default: noneSettings (setting) Type: JSON Required: no Default: none
Date (biz_date)Date (biz_date) Type: date Required: no Default: noneDate (biz_date) Type: date Required: no Default: noneDate (biz_date) Type: date Required: no Default: none
Updated at (updated_at)Updated at (updated_at) Type: datetime Required: no Default: noneUpdated at (updated_at) Type: datetime Required: no Default: noneUpdated at (updated_at) Type: datetime Required: no Default: none
Active (active)Active (active) Type: flag Required: no Default: noneActive (active) Type: flag Required: no Default: noneActive (active) Type: flag Required: no Default: none

Record list

RowPrimary keyStatusChanged fieldsDetails
1Code (code)=001ChangedPrice (price): 1200.00 → 1500.00View comparison details
2Code (code)=002DeletedCode (code): 002 → — Product name (name): 商品B → — Price (price): 2400.50 → — Note (memo): 初期メモ → — Settings (setting): {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} → — Date (biz_date): 2026-10-03 → — Updated at (updated_at): 2026-10-03T12:34:56.123456 → — Active (active): 1 → —View comparison details
3Code (code)=003UnchangedNoneView comparison details
4Code (code)=004AddedCode (code): — → 004 Product name (name): — → 商品D Price (price): — → 4800.00 Note (memo): — → 初期メモ Settings (setting): — → {"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}} Date (biz_date): — → 2026-10-03 Updated at (updated_at): — → 2026-10-03T12:34:56.123456 Active (active): — → 1View comparison details
Record 1 / Code (code)=001 comparison
FieldAt the start of editingCurrent master dataProject edits
Code (code)001001001
Product name (name)商品A商品A商品A
Price (price)1200.001200.001500.00
Note (memo)初期メモ初期メモ初期メモ
Settings (setting){"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}{"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}{"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}
Date (biz_date)2026-10-032026-10-032026-10-03
Updated at (updated_at)2026-10-03T12:34:56.1234562026-10-03T12:34:56.1234562026-10-03T12:34:56.123456
Active (active)111
Record 2 / Code (code)=002 comparison
FieldAt the start of editingCurrent master dataProject edits
Code (code)002002—
Product name (name)商品B商品B—
Price (price)2400.502400.50—
Note (memo)初期メモ初期メモ—
Settings (setting){"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}{"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}—
Date (biz_date)2026-10-032026-10-03—
Updated at (updated_at)2026-10-03T12:34:56.1234562026-10-03T12:34:56.123456—
Active (active)11—
Record 3 / Code (code)=003 comparison
FieldAt the start of editingCurrent master dataProject edits
Code (code)003003003
Product name (name)商品C商品C商品C
Price (price)3600.003600.003600.00
Note (memo)初期メモ初期メモ初期メモ
Settings (setting){"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}{"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}{"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}
Date (biz_date)2026-10-032026-10-032026-10-03
Updated at (updated_at)2026-10-03T12:34:56.1234562026-10-03T12:34:56.1234562026-10-03T12:34:56.123456
Active (active)111
Record 4 / Code (code)=004 comparison
FieldAt the start of editingCurrent master dataProject edits
Code (code)——004
Product name (name)——商品D
Price (price)——4800.00
Note (memo)——初期メモ
Settings (setting)——{"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}
Date (biz_date)——2026-10-03
Updated at (updated_at)——2026-10-03T12:34:56.123456
Active (active)——1

Overlapping changes with other projects: 0 columns, 0 records

CATEGORYCATEGORY

Column changes & definitions (2 columns)
ColumnAt the start of editingCurrent master dataProject edits
Code (code)Code (code) Type: string Length/precision: 3 Required: yes Default: noneCode (code) Type: string Length/precision: 3 Required: yes Default: noneCode (code) Type: string Length/precision: 3 Required: yes Default: none
Category name (name)Category name (name) Type: string Length/precision: 100 Required: no Default: noneCategory name (name) Type: string Length/precision: 100 Required: no Default: noneCategory name (name) Type: string Length/precision: 100 Required: no Default: none

Record list

RowPrimary keyStatusChanged fieldsDetails
1Code (code)=C01UnchangedNoneView comparison details
2Code (code)=C02ChangedCategory name (name): 日用品 → 生活雑貨View comparison details
Record 1 / Code (code)=C01 comparison
FieldAt the start of editingCurrent master dataProject edits
Code (code)C01C01C01
Category name (name)食品食品食品
Record 2 / Code (code)=C02 comparison
FieldAt the start of editingCurrent master dataProject edits
Code (code)C02C02C02
Category name (name)日用品日用品生活雑貨

Overlapping changes with other projects: 0 columns, 0 records

Generated SQL

Generated SQL for PRODUCT

1. Column definition changes before data changes (DDL)

なし

2. Record additions, updates, and deletions (DML)

START TRANSACTION;
UPDATE `PRODUCT` SET `price` = 1500.00 WHERE `code` = '001';
DELETE FROM `PRODUCT` WHERE `code` = '002';
INSERT INTO `PRODUCT` (`code`,`name`,`price`,`memo`,`setting`,`biz_date`,`updated_at`,`active`) VALUES ('004','商品D',4800.00,'初期メモ',CAST('{"item":"AAA","item1":123,"item2":true,"item3":null,"item4":["AAA",123,false],"item5":{"item":"あああ","item1":"BBB","item2":111}}' AS JSON),DATE '2026-10-03',TIMESTAMP '2026-10-03 12:34:56.123456',1);
COMMIT;

3. Column definition changes after data changes (DDL)

なし
Generated SQL for CATEGORYCATEGORY

1. Column definition changes before data changes (DDL)

なし

2. Record additions, updates, and deletions (DML)

START TRANSACTION;
UPDATE `CATEGORYCATEGORY` SET `name` = '生活雑貨' WHERE `code` = 'C02';
COMMIT;

3. Column definition changes after data changes (DDL)

なし