【无标题】

最新推荐文章于 2025-05-07 19:46:16 发布

西湫

最新推荐文章于 2025-05-07 19:46:16 发布

阅读量111

点赞数

文章标签： java 前端 javascript

本文链接：https://blog.youkuaiyun.com/qq_43890604/article/details/131650715

版权

文章描述了三个数据库表的创建，分别是会议配置表，包含了可容纳人数、云会议室和是否需要投影等信息；进线申请表，记录进线类型、开始和结束时间等；以及欢迎语表，存储是否需要欢迎语和欢迎语内容。这些表用于管理办公室客户访问的相关设置和流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

会议配置表

CREATE COLUMN TABLE

    "PDM_SIT"."OFFICE_CUSTOMER_VISIT_MEETING_CONFIGURE" 
    ("CAPACITY_NUM" NVARCHAR(20),
    "CLOUD_MEETING" NVARCHAR(100),
    "CLOUD_MEETING_TOOL" NVARCHAR(100),
    "IS_NEED_PROJECTION" NVARCHAR(10),
    "SERVE" NVARCHAR(100),
    "IS_NEED_NAMEPLATE" NVARCHAR(10)) UNLOAD PRIORITY 5 AUTO MERGE ;

COMMENT ON

COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_MEETING_CONFIGURE"."CAPACITY_NUM" IS '可容纳人数';

COMMENT ON

COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_MEETING_CONFIGURE"."CLOUD_MEETING" IS '云会议室';

COMMENT ON

COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_MEETING_CONFIGURE"."CLOUD_MEETING_TOOL" IS '云会议室工具';

COMMENT ON

COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_MEETING_CONFIGURE"."IS_NEED_PROJECTION" IS '是否需要投影';

COMMENT ON

COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_MEETING_CONFIGURE"."SERVE" IS '服务';

COMMENT ON

COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_MEETING_CONFIGURE"."IS_NEED_NAMEPLATE" IS '是否需要铭牌'

进线申请表

CREATE COLUMN TABLE
    "PDM_SIT"."OFFICE_CUSTOMER_VISIT_INCOME_LINE_APPLICATION" 
    ("INCOME_LINE_TYPE" NVARCHAR(20),
    "CREATE_TIME" NVARCHAR(100),
    "END_TIME" NVARCHAR(100),
    "JOINT_NUMBER" NVARCHAR(10),
    "REMARK" NVARCHAR(100)) UNLOAD PRIORITY 5 AUTO MERGE ;

COMMENT ON
COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_INCOME_LINE_APPLICATION"."INCOME_LINE_TYPE" IS '进线类型';

COMMENT ON
COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_INCOME_LINE_APPLICATION"."CREATE_TIME" IS '开始时间';

COMMENT ON
COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_INCOME_LINE_APPLICATION"."END_TIME" IS '结束时间';

COMMENT ON
COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_INCOME_LINE_APPLICATION"."JOINT_NUMBER" IS '对接人';

COMMENT ON
COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_INCOME_LINE_APPLICATION"."REMARK" IS '备注'

欢迎语表

CREATE COLUMN TABLE
    "PDM_SIT"."OFFICE_CUSTOMER_VISIT_WELCOME_LANGUAGE" 
    ("RESERVE_NUMBER" NVARCHAR(100),
    "IS_NEED_WELCOME_LANGUAGE" NVARCHAR(100),
    "WELCOME_LANGUAGE_CONTENT" NVARCHAR(100)) UNLOAD PRIORITY 5 AUTO MERGE ;

COMMENT ON
COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_WELCOME_LANGUAGE"."IS_NEED_WELCOME_LANGUAGE" IS '是否需要欢迎语';

COMMENT ON
COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_WELCOME_LANGUAGE"."WELCOME_LANGUAGE_CONTENT" IS '欢迎语内容';

COMMENT ON
COLUMN "PDM_SIT"."OFFICE_CUSTOMER_VISIT_WELCOME_LANGUAGE"."RESERVE_NUMBER" IS '预约码'