distribution work

Tables (4)

ADMIN

  • ADMIN_ID — Primary key — NOT NULL

ASSIGN_JOB_INFO

  • ASSIGN_ID — Primary key — NOT NULL
  • ACCEPT_ID — Foreign key → MV_T_I_ACCEPT.ACCEPT_ID — NOT NULL
  • ADMIN_ID (ADMIN_ID2) — Foreign key → ADMIN.ADMIN_ID — NOT NULL

ASSIGN_JOB_INFO_LOG

  • LOG_ID — Primary key — NOT NULL
  • ASSIGN_ID — Foreign key → ASSIGN_JOB_INFO.ASSIGN_ID — NOT NULL

MV_T_I_ACCEPT

  • ACCEPT_ID — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6