Startsida Utforska Hjälp
Registrera dig Logga in
kevinlan
/
autocde2.0
2
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: 75a48a37c3
Grenar Taggar
autocde2.0
/
database
/
seeders
/
sql
/
custom_fields.sql

custom_fields.sql 16 KB
Historik Rå

12345678910111213141516171819 
  1. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (1, '1', 'Originator', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Gold Banner Construction &  Development Ltd.\", \"zh\": null}, \"value\": \"GBC\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": null, \"remark\": null}]');
    2. 

  2. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (2, '1', 'Volume', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"All zone\", \"zh\": null}, \"value\": \"NA\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": null, \"remark\": null}]');
    3. 

  3. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (3, '1', 'Location', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Building\", \"zh\": null}, \"value\": \"BD\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": null, \"remark\": null}]');
    4. 

  4. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (4, '1', 'Discipline', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Architectural\", \"zh\": null}, \"value\": \"AR\", \"remark\": null}, {\"lang\": {\"en\": \"Structural\", \"zh\": null}, \"value\": \"ST\", \"remark\": null}, {\"lang\": {\"en\": \"Building Service\", \"zh\": null}, \"value\": \"BS\", \"remark\": null}, {\"lang\": {\"en\": \"Multiple disciplines for Combined Model\", \"zh\": null}, \"value\": \"ZZ\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": null, \"remark\": null}]');
    5. 

  5. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (5, '1', 'Type', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"3D Model File\", \"zh\": null}, \"value\": \"M3\", \"remark\": null}, {\"lang\": {\"en\": \"Combined Model File\", \"zh\": null}, \"value\": \"CM\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": null, \"remark\": null}]');
    6. 

  6. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (6, '1', 'characteristic', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Temporary Works\", \"zh\": null}, \"value\": \"T\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": null, \"remark\": null}]');
    7. 

  7. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (7, '1', 'Sequential number', '{\"en\": null, \"zh\": null}', 1, '[{\"lang\": {\"en\": \"(Text field)\", \"zh\": null}, \"value\": \"(Text field)\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": \"(Text field)\", \"remark\": null}]');
    8. 

  8. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (8, 'Task', 'Doc_Stage', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Strategic Definition\", \"zh\": null}, \"value\": \"0\", \"remark\": null}, {\"lang\": {\"en\": \"Preparation and Briefing\", \"zh\": null}, \"value\": \"1\", \"remark\": null}, {\"lang\": {\"en\": \"Concept Design\", \"zh\": null}, \"value\": \"2\", \"remark\": null}, {\"lang\": {\"en\": \"Spatial Coordination\", \"zh\": null}, \"value\": \"3\", \"remark\": null}, {\"lang\": {\"en\": \"Technical Design\", \"zh\": null}, \"value\": \"4\", \"remark\": null}, {\"lang\": {\"en\": \"Manufacturing and Construction\", \"zh\": null}, \"value\": \"5\", \"remark\": null}, {\"lang\": {\"en\": \"Handover\", \"zh\": null}, \"value\": \"6\", \"remark\": null}, {\"lang\": {\"en\": \"Use\", \"zh\": null}, \"value\": \"7\", \"remark\": null}]', 1, NULL, NULL);
    9. 

  9. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (9, 'Task', 'Doc_Type', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Drawing Rendition (DS -Drawing Submission)\", \"zh\": null}, \"value\": \"DR\", \"remark\": null}, {\"lang\": {\"en\": \"Programme\", \"zh\": null}, \"value\": \"PR\", \"remark\": null}, {\"lang\": {\"en\": \"Request for Information\", \"zh\": null}, \"value\": \"RI (RFl)\", \"remark\": null}, {\"lang\": {\"en\": \"Technical Submission (incl. MS - Material Submission & MSS - Method Statement)\", \"zh\": null}, \"value\": \"TS\", \"remark\": null}, {\"lang\": {\"en\": \"Architect\'s Instruction\", \"zh\": null}, \"value\": \"Al\", \"remark\": null}, {\"lang\": {\"en\": \"Payment\", \"zh\": null}, \"value\": \"P\", \"remark\": null}, {\"lang\": {\"en\": \"O-Chart\", \"zh\": null}, \"value\": \"OC\", \"remark\": null}, {\"lang\": {\"en\": \"Notice of Delay\", \"zh\": null}, \"value\": \"NOD\", \"remark\": null}, {\"lang\": {\"en\": \"Request for Architect\'s Instruction\", \"zh\": null}, \"value\": \"RAl\", \"remark\": null}, {\"lang\": {\"en\": \"Confrmation of Instruction\", \"zh\": null}, \"value\": \"COl\", \"remark\": null}, {\"lang\": {\"en\": \"Calculation\", \"zh\": null}, \"value\": \"CA\", \"remark\": null}, {\"lang\": {\"en\": \"Testing & Commissioning\", \"zh\": null}, \"value\": \"T&C\", \"remark\": null}, {\"lang\": {\"en\": \"Statutory Permit\", \"zh\": null}, \"value\": \"SP\", \"remark\": null}, {\"lang\": {\"en\": \"Site Inspection Request\", \"zh\": null}, \"value\": \"SIR\", \"remark\": null}, {\"lang\": {\"en\": \"3D Model File\", \"zh\": null}, \"value\": \"M3\", \"remark\": null}]', 1, NULL, NULL);
    10. 

  10. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (10, 'Task', 'Task_Type', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Construction Programme\", \"zh\": null}, \"value\": \"CP\", \"remark\": null}, {\"lang\": {\"en\": \"Request for Information\", \"zh\": null}, \"value\": \"RFI\", \"remark\": null}, {\"lang\": {\"en\": \"Request for Architect\'s Instruction\", \"zh\": null}, \"value\": \"RAI\", \"remark\": null}, {\"lang\": {\"en\": \"Architect\'s Instruction\", \"zh\": null}, \"value\": \"AI\", \"remark\": null}, {\"lang\": {\"en\": \"Technical Submission\", \"zh\": null}, \"value\": \"TS\", \"remark\": null}, {\"lang\": {\"en\": \"Method Statement Submission\", \"zh\": null}, \"value\": \"MSS\", \"remark\": null}, {\"lang\": {\"en\": \"Material Submission\", \"zh\": null}, \"value\": \"MS\", \"remark\": null}, {\"lang\": {\"en\": \"Model Submission\", \"zh\": null}, \"value\": \"MOS\", \"remark\": null}, {\"lang\": {\"en\": \"Drawing Submission\", \"zh\": null}, \"value\": \"SDS\", \"remark\": null}, {\"lang\": {\"en\": \"Health and Safety\", \"zh\": null}, \"value\": \"HS\", \"remark\": null}, {\"lang\": {\"en\": \"Confirmation of Instruction\", \"zh\": null}, \"value\": \"COI\", \"remark\": null}, {\"lang\": {\"en\": \"O-Chart\", \"zh\": null}, \"value\": \"OC\", \"remark\": null}, {\"lang\": {\"en\": \"Submission Schedule\", \"zh\": null}, \"value\": \"SSH\", \"remark\": null}, {\"lang\": {\"en\": \"Payment Application\", \"zh\": null}, \"value\": \"PA\", \"remark\": null}]', 1, NULL, NULL);
    11. 

  11. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (11, 'Container', 'Doc_Stage', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Strategic Definition\", \"zh\": null}, \"value\": \"0\", \"remark\": null}, {\"lang\": {\"en\": \"Preparation and Briefing\", \"zh\": null}, \"value\": \"1\", \"remark\": null}, {\"lang\": {\"en\": \"Concept Design\", \"zh\": null}, \"value\": \"2\", \"remark\": null}, {\"lang\": {\"en\": \"Spatial Coordination\", \"zh\": null}, \"value\": \"3\", \"remark\": null}, {\"lang\": {\"en\": \"Technical Design\", \"zh\": null}, \"value\": \"4\", \"remark\": null}, {\"lang\": {\"en\": \"Manufacturing and Construction\", \"zh\": null}, \"value\": \"5\", \"remark\": null}, {\"lang\": {\"en\": \"Handover\", \"zh\": null}, \"value\": \"6\", \"remark\": null}, {\"lang\": {\"en\": \"Use\", \"zh\": null}, \"value\": \"7\", \"remark\": null}]', 1, NULL, NULL);
    12. 

  12. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (12, 'Container', 'Doc_Type', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Drawing Rendition (DS -Drawing Submission)\", \"zh\": null}, \"value\": \"DR\", \"remark\": null}, {\"lang\": {\"en\": \"Programme\", \"zh\": null}, \"value\": \"PR\", \"remark\": null}, {\"lang\": {\"en\": \"Request for Information\", \"zh\": null}, \"value\": \"RI (RFl)\", \"remark\": null}, {\"lang\": {\"en\": \"Technical Submission (incl. MS - Material Submission & MSS - Method Statement)\", \"zh\": null}, \"value\": \"TS\", \"remark\": null}, {\"lang\": {\"en\": \"Architect\'s Instruction\", \"zh\": null}, \"value\": \"Al\", \"remark\": null}, {\"lang\": {\"en\": \"Payment\", \"zh\": null}, \"value\": \"P\", \"remark\": null}, {\"lang\": {\"en\": \"O-Chart\", \"zh\": null}, \"value\": \"OC\", \"remark\": null}, {\"lang\": {\"en\": \"Notice of Delay\", \"zh\": null}, \"value\": \"NOD\", \"remark\": null}, {\"lang\": {\"en\": \"Request for Architect\'s Instruction\", \"zh\": null}, \"value\": \"RAl\", \"remark\": null}, {\"lang\": {\"en\": \"Confrmation of Instruction\", \"zh\": null}, \"value\": \"COl\", \"remark\": null}, {\"lang\": {\"en\": \"Calculation\", \"zh\": null}, \"value\": \"CA\", \"remark\": null}, {\"lang\": {\"en\": \"Testing & Commissioning\", \"zh\": null}, \"value\": \"T&C\", \"remark\": null}, {\"lang\": {\"en\": \"Statutory Permit\", \"zh\": null}, \"value\": \"SP\", \"remark\": null}, {\"lang\": {\"en\": \"Site Inspection Request\", \"zh\": null}, \"value\": \"SIR\", \"remark\": null}, {\"lang\": {\"en\": \"3D Model File\", \"zh\": null}, \"value\": \"M3\", \"remark\": null}]', 1, NULL, NULL);
    13. 

  13. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (13, 'File', 'Doc_Stage', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Strategic Definition\", \"zh\": null}, \"value\": \"0\", \"remark\": null}, {\"lang\": {\"en\": \"Preparation and Briefing\", \"zh\": null}, \"value\": \"1\", \"remark\": null}, {\"lang\": {\"en\": \"Concept Design\", \"zh\": null}, \"value\": \"2\", \"remark\": null}, {\"lang\": {\"en\": \"Spatial Coordination\", \"zh\": null}, \"value\": \"3\", \"remark\": null}, {\"lang\": {\"en\": \"Technical Design\", \"zh\": null}, \"value\": \"4\", \"remark\": null}, {\"lang\": {\"en\": \"Manufacturing and Construction\", \"zh\": null}, \"value\": \"5\", \"remark\": null}, {\"lang\": {\"en\": \"Handover\", \"zh\": null}, \"value\": \"6\", \"remark\": null}, {\"lang\": {\"en\": \"Use\", \"zh\": null}, \"value\": \"7\", \"remark\": null}]', 1, NULL, NULL);
    14. 

  14. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (15, 'File', 'Doc_Type', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Drawing Rendition (DS -Drawing Submission)\", \"zh\": null}, \"value\": \"DR\", \"remark\": null}, {\"lang\": {\"en\": \"Programme\", \"zh\": null}, \"value\": \"PR\", \"remark\": null}, {\"lang\": {\"en\": \"Request for Information\", \"zh\": null}, \"value\": \"RI (RFl)\", \"remark\": null}, {\"lang\": {\"en\": \"Technical Submission (incl. MS - Material Submission & MSS - Method Statement)\", \"zh\": null}, \"value\": \"TS\", \"remark\": null}, {\"lang\": {\"en\": \"Architect\'s Instruction\", \"zh\": null}, \"value\": \"Al\", \"remark\": null}, {\"lang\": {\"en\": \"Payment\", \"zh\": null}, \"value\": \"P\", \"remark\": null}, {\"lang\": {\"en\": \"O-Chart\", \"zh\": null}, \"value\": \"OC\", \"remark\": null}, {\"lang\": {\"en\": \"Notice of Delay\", \"zh\": null}, \"value\": \"NOD\", \"remark\": null}, {\"lang\": {\"en\": \"Request for Architect\'s Instruction\", \"zh\": null}, \"value\": \"RAl\", \"remark\": null}, {\"lang\": {\"en\": \"Confrmation of Instruction\", \"zh\": null}, \"value\": \"COl\", \"remark\": null}, {\"lang\": {\"en\": \"Calculation\", \"zh\": null}, \"value\": \"CA\", \"remark\": null}, {\"lang\": {\"en\": \"Testing & Commissioning\", \"zh\": null}, \"value\": \"T&C\", \"remark\": null}, {\"lang\": {\"en\": \"Statutory Permit\", \"zh\": null}, \"value\": \"SP\", \"remark\": null}, {\"lang\": {\"en\": \"Site Inspection Request\", \"zh\": null}, \"value\": \"SIR\", \"remark\": null}, {\"lang\": {\"en\": \"3D Model File\", \"zh\": null}, \"value\": \"M3\", \"remark\": null}]', 1, NULL, NULL);
    15. 

  15. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (16, '1', 'Building Type', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Podium\", \"zh\": null}, \"value\": \"POD\", \"remark\": null}, {\"lang\": {\"en\": \"Basement\", \"zh\": null}, \"value\": \"BAS\", \"remark\": null}, {\"lang\": {\"en\": \"Typical Levels\", \"zh\": null}, \"value\": \"TYP\", \"remark\": null}, {\"lang\": {\"en\": \"Roof Level\", \"zh\": null}, \"value\": \"RF\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": null, \"remark\": null}]');
    16. 

  16. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (17, '1', 'Discipline / (Sub-discipline)', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Architect / Architectural\", \"zh\": null}, \"value\": \"AR\", \"remark\": null}, {\"lang\": {\"en\": \"Building Services Engineer / Building Services\", \"zh\": null}, \"value\": \"BS\", \"remark\": null}, {\"lang\": {\"en\": \"Contractor\", \"zh\": null}, \"value\": \"CN\", \"remark\": null}, {\"lang\": {\"en\": \"Civil Engineer\", \"zh\": null}, \"value\": \"CV\", \"remark\": null}, {\"lang\": {\"en\": \"MVAC Engineer / Mechanical\", \"zh\": null}, \"value\": \"ME\", \"remark\": null}, {\"lang\": {\"en\": \"Plumbing Engineer\", \"zh\": null}, \"value\": \"PL\", \"remark\": null}, {\"lang\": {\"en\": \"General (non-disciplinary)\", \"zh\": null}, \"value\": \"XX\", \"remark\": null}, {\"lang\": {\"en\": \"Multiple disciplines for combined model\", \"zh\": null}, \"value\": \"ZZ\", \"remark\": null}, {\"lang\": {\"en\": \"Structural Engineering\", \"zh\": null}, \"value\": \"SE\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": null, \"remark\": null}]');
    17. 

  17. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (18, '1', 'Originator', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Llewellyn & Partners Co. Ltd.\", \"zh\": null}, \"value\": \"LPC\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": null, \"remark\": null}]');
    18. 

  18. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (19, '1', 'Sequential Number', '{\"en\": null, \"zh\": null}', 1, '[{\"lang\": {\"en\": \"(Text field)\", \"zh\": null}, \"value\": \"(Text field)\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": \"(Text field)\", \"remark\": null}]');
    19. 

  19. INSERT INTO `custom_fields` (`id`, `group`, `key`, `label`, `type`, `options`, `required`, `remark`, `inputs`) VALUES (20, '1', 'Type / (Characteristic)', '{\"en\": null, \"zh\": null}', 3, '[{\"lang\": {\"en\": \"Animation file (of a model)\", \"zh\": null}, \"value\": \"AF\", \"remark\": null}, {\"lang\": {\"en\": \"Bill of quantities\", \"zh\": null}, \"value\": \"BQ\", \"remark\": null}, {\"lang\": {\"en\": \"Calculation\", \"zh\": null}, \"value\": \"CA\", \"remark\": null}, {\"lang\": {\"en\": \"2D model\", \"zh\": null}, \"value\": \"M2\", \"remark\": null}, {\"lang\": {\"en\": \"3D model\", \"zh\": null}, \"value\": \"M3\", \"remark\": null}, {\"lang\": {\"en\": \"Report\", \"zh\": null}, \"value\": \"RP\", \"remark\": null}, {\"lang\": {\"en\": \"Drawing rendition\", \"zh\": null}, \"value\": \"DR\", \"remark\": null}, {\"lang\": {\"en\": \"Programme\", \"zh\": null}, \"value\": \"PR\", \"remark\": null}, {\"lang\": {\"en\": \"Health and safety\", \"zh\": null}, \"value\": \"HS\", \"remark\": null}]', 1, NULL, '[{\"lang\": {\"en\": null, \"zh\": null}, \"value\": null, \"remark\": null}]');
    20.