test
Tables (5)
project_field
- id — BIGINT
- project_id — BIGINT — NOT NULL
- field_name — VARCHAR(255) — NOT NULL
- field_type — VARCHAR(32) — NOT NULL
- order_index — INTEGER — NOT NULL
- is_required_flag — SMALLINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
project_record
- id — BIGINT
- project_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
project_table
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- is_open_flag — SMALLINT — NOT NULL
- user_id — BIGINT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
project_value
- record_id — BIGINT — Primary key — NOT NULL
- field_id — BIGINT — Primary key — NOT NULL
- value_json — CLOB
- value_text — VARCHAR(2000)
- value_number — DECIMAL(38, 10)
- value_date — DATE
- value_bool_flag — SMALLINT
- 0) — + — NOT NULL
- 0) — + — NOT NULL
- 0) — <=
task_table
- id — BIGINT
- record_id — BIGINT — NOT NULL
- user_id — BIGINT
- progress — VARCHAR(32) — NOT NULL
- name — VARCHAR(120) — NOT NULL
- remark — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL