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