DB Editor

customers(10) equipment(4) logs(18) rentals(10)

id INTEGER name TEXT NOT NULL model TEXT sn TEXT category TEXT purchase_price REAL daily_rate REAL status TEXT notes TEXT is_auto INTEGER created_at DATETIME updated_at DATETIME

id🔑	name	category	status	is_auto	created_at	updated_at
1	大疆pocket3②	手持设备	闲置	1	2026-04-14 06:16:37	2026-04-20 23:44:18
2	大疆pocket3①	手持设备	闲置	1	2026-04-14 06:26:24	2026-04-19 08:30:02
3	大疆pocket3③	手持设备	租出	1	2026-04-14 06:28:08	2026-04-20 03:19:47
5	大疆pocket4①	手持设备	已预订	1	2026-04-18 11:57:04	2026-04-18 11:57:55

插入新行

name TEXT (必填)

model TEXT

sn TEXT

category TEXT

purchase_price REAL

daily_rate REAL

status TEXT

notes TEXT

is_auto INTEGER

created_at DATETIME

updated_at DATETIME

SQL