title: table zt_project
author: Zhu Jinyong
version: "1.0"
fields:
  - field: id
    range: 1-100
  - field: project
    range: 0{10},1-10{100!}
  - field: model
    range: "[]{10},[scrum,waterfall,kanban,agileplus,waterfallplus]{30!}"
  - field: name
    note: "名称"
    fields:
    - field: name1
      range: '项目集{10},项目{100}'
    - field: name2
      range: 1-10000
  - field: type
    range: program{10},project{100}
  - field: status
    range: wait{2},doing{4},suspended,closed
  - field: lifetime
    range:
  - field: budget
    range: 900000-1:100
  - field: budgetUnit
    range: CNY,USD
  - field: attribute
    note: "Only stage has attribute"
    range:
  - field: percent
    range: 1-100:R
  - field: milestone
    note: "Is it milestone"
    range: 0
  - field: output
    note: "Output document"
    range:
  - field: auth
    note: "Only project has auth"
    range: "extend"
  - field: parent
    range: 0{10},1-10{100!}
  - field: path
    fields:
      - field: path1
        prefix: ","
        range: 1-10
      - field: path2
        prefix: ","
        range: "[]{10},11-100"
        postfix: ","
  - field: grade
    range: "2"
  - field: code
    fields:
      - field: code1
        range: program{10},project{100}
      - field: code2
        range: 1-10,1-10000
  - field: begin
    range: "(-3M)-(+M):1D"
    type: timestamp
    format: "YY-MM-DD hh:mm:ss"
  - field: end
    range: "(+5w)-(+2M):1D"
    type: timestamp
    format: "YY-MM-DD hh:mm:ss"
  - field: PO
    range:
  - field: PM
    range:
  - field: QD
    range:
  - field: RD
    range:
  - field: team
    range:
  - field: acl
    range: open,private,program
  - field: order
    range: 5-10000:5
  - field: openedVersion
    range: "16.5"
  - field: openedDate
    range: "(-3M)-(+M):1D"
    type: timestamp
    format: "YY-MM-DD hh:mm:ss"
  - field: multiple
    note: "有无迭代"
    range: 1
  - field: category
    range: ''
  - field: hasProduct
    range: 1
  - field: progress
    range: '0.00'
  - field: deleted
    range: 0