SQLite Web: billing.db

Insert row into odps

name

VARCHAR(100) NOT NULL

code

VARCHAR(50) NOT NULL

latitude

DECIMAL(10,8) NOT NULL

longitude

DECIMAL(11,8) NOT NULL

address

TEXT

capacity

INTEGER (default 64)

used_ports

INTEGER (default 0)

status

VARCHAR(20) (default 'active')

installation_date

DATE

notes

TEXT

created_at

DATETIME (default CURRENT_TIMESTAMP)

updated_at

DATETIME (default CURRENT_TIMESTAMP)

parent_odp_id

INTEGER

is_pole

INTEGER (default 0)

Cancel