EmploymentSite/doc/待更新脚本.txt

-- 2024.8.6
create table pc_signin
(
   SigninId             varchar(50) not null comment '唯一标识',
   SiteID               varchar(50) comment '所属驿站',
   SigninType           int comment '打卡类型，字典：SigninType',
   CompanyID            varchar(50) comment '走访企业',
   JobuserID            varchar(50) comment '走访人员',
   SigninTime           datetime comment '打卡时间',
   Content              text comment '服务内容',
   Longitude            varchar(50) comment '经度',
   Latitude             varchar(50) comment '纬度',
   RecordStatus         int comment '状态',
   CreateUserID         varchar(50) comment '创建人',
   CreateTime           datetime comment '创建时间',
   ModifyUserID         varchar(50) comment '修改人',
   ModifyTime           datetime comment '修改时间',
   primary key (SigninId)
);

alter table pc_signin add constraint FK_Pc_Signin_Ref_Company foreign key (CompanyID)
      references pc_company (CompanyID) on delete restrict on update restrict;

alter table pc_signin add constraint FK_Pc_Signin_Ref_JobUser foreign key (JobuserID)
      references pc_jobuser (JobuserID) on delete restrict on update restrict;

alter table pc_signin add constraint FK_Pc_Signin_Ref_Site foreign key (SiteID)
      references pc_site (SiteID) on delete restrict on update restrict;


 INSERT INTO `sys_dictionary` (`DictionaryCode`, `Name`, `OrderNo`, `RecordStatus`) VALUES
 ('SigninType', '打卡类型', 200, 1);
 INSERT INTO `sys_dictionary_item` (`DictionaryItemID`, `Code`, `DictionaryCode`, `Value`, `Name`, `OrderNo`, `RecordStatus`, `IsEditable`) VALUES
 ('ac93ede5-538d-11ef-8d63-7085c2a9999e', '', 'SigninType', 1, '走访企业', 1, 1, 0),
 ('b100cbf2-538d-11ef-8d63-7085c2a9999e', '', 'SigninType', 2, '走访人员', 2, 1, 0),
 ('b4ec8c51-538d-11ef-8d63-7085c2a9999e', '', 'SigninType', 3, '其他外联事项', 3, 1, 0);