FF
Tables (7)
api_keys
- id — bigint(20) — Primary key — NOT NULL
- active — bit(1) — NOT NULL
- api_key — varchar(255) — NOT NULL
- client_email — varchar(255) — NOT NULL
- client_name — varchar(255) — NOT NULL
- created_at — datetime(6) — NOT NULL
- daily_limit — bigint(20)
- expires_at — datetime(6) — NOT NULL
- last_used_at — datetime(6)
- monthly_limit — bigint(20)
- user_id — bigint(20) — Foreign key → users.id
- total_usage_count — bigint(20)
- description — varchar(255)
business_status
- id — bigint(20) — Primary key — NOT NULL
- business_number — varchar(255)
- check_date — varchar(255)
- created_at — datetime(6)
- status — varchar(255)
- user_id — bigint(20) — Foreign key → users.id
- api_key_id — bigint(20) — Foreign key → api_keys.id
certificates
- id — bigint(20) — Primary key — NOT NULL
- cert_name — varchar(255)
- created_at — datetime(6)
- der2pem — text
- issuer_dn — varchar(255)
- key2pem — text
- owner_name — varchar(255)
- password — varchar(255)
- path — varchar(255)
- serial_number — varchar(255)
- status — varchar(255)
- updated_at — datetime(6)
- valid_from — date
- valid_to — date
system_settings
- setting_key — varchar(100) — Primary key — NOT NULL
- setting_value — varchar(500)
todos
- id — bigint(20) — Primary key — NOT NULL
- completed — bit(1) — NOT NULL
- created_at — datetime(6)
- description — varchar(1000)
- title — varchar(255) — NOT NULL
- updated_at — datetime(6)
users
- id — bigint(20) — Primary key — NOT NULL
- birth_date — date
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- phone_number — varchar(255)
- role — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
vehicle_info
- id — bigint(20) — Primary key — NOT NULL
- car_type — varchar(255)
- color — varchar(255)
- created_at — datetime(6)
- err_msg — varchar(255)
- error_code — varchar(255)
- error_yn — varchar(255)
- first_reg_dt — varchar(255)
- owner — varchar(255)
- reg_no — varchar(255)
- updated_at — datetime(6)
- year — varchar(255)
- owner_name — varchar(255)