-- https://www.phpmyadmin.net/
--
-- 主機: localhost
-- 產生時間： 2025 年 05 月 13 日 13:50
-- 伺服器版本: 5.7.41
-- PHP 版本： 5.6.40

START TRANSACTION;



--
-- 資料庫： `ansnAdb`
--

-- --------------------------------------------------------

--
-- 資料表結構 `platform_users`
--

CREATE TABLE `platform_users` (
  `puid` int(10) NOT NULL,
  `crm_account` varchar(120) NOT NULL COMMENT '帳號(工號)',
  `crm_password` varchar(255) NOT NULL COMMENT '密碼',
  `username` varchar(100) NOT NULL COMMENT '姓名',
  `email` varchar(100) NOT NULL COMMENT '信箱',
  `groupname` varchar(100) NOT NULL COMMENT '所屬成員',
  `job_title` varchar(100) NOT NULL COMMENT '職稱',
  `telephone` varchar(100) NOT NULL COMMENT '聯絡電話',
  `cellphone` varchar(100) NOT NULL COMMENT '手機號碼',
  `department_main` varchar(30) NOT NULL COMMENT '所屬部門',
  `department_sub` varchar(30) NOT NULL COMMENT '所屬部門-明細',
  `userstatus` int(10) NOT NULL COMMENT '使用者狀態',
  `UserMainPage` text NOT NULL COMMENT '主選單',
  `UserSubPage` text NOT NULL COMMENT '子選單',
  `logindate` datetime NOT NULL,
  `session_id` varchar(255) NOT NULL,
  `CreateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '建立時間'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='CRM 使用者表';

--
-- 資料表的匯出資料 `platform_users`
--

INSERT INTO `platform_users` (`puid`, `crm_account`, `crm_password`, `username`, `email`, `groupname`, `job_title`, `telephone`, `cellphone`, `department_main`, `department_sub`, `userstatus`, `UserMainPage`, `UserSubPage`, `logindate`, `session_id`, `CreateTime`) VALUES
(1, 'wemelog', '$2y$10$zHmwaVcaDerh4B8zmLBOc.h/0ScYTZrVT4dV5mGx2Idt3Zqx.jY4K', 'wemelog', 'ericw030@gmail.com', '員工,系統管理者', '健檢管理師', '0937038162', '0937038162', '3', '3', 1, '1,2,3,9,10,11', '1,2,3,4,5,6,7,9,26,29,10,12,19,20,21,24,25,30,32,33', '2025-03-04 09:21:49', 'sl1fu0hlis18n4a9nvh5i03654', '2024-10-12 03:42:55'),
(4, '12345', '$2y$10$zHmwaVcaDerh4B8zmLBOc.h/0ScYTZrVT4dV5mGx2Idt3Zqx.jY4K', 'Eric Wang', 'ericw030@gmail.com', '員工,系統管理者', '健檢管理師', '0937038162', '0937038162', '3', '3', 1, '1,2,3,9,10,11', '1,2,3,4,5,6,7,9,26,29,10,12,19,20,21,24,25,30,32,33', '2025-05-13 08:05:26', '40h63528eib2bqui1ct5t5ika6', '2024-10-12 03:42:55'),
(8, 'q234567', '$2y$10$2UyPFRGSdEDGXMv9qqmozufe0Hu03Itmg8W.gVUMFB2krxRxa8.DO', '11DDD', 'test0@demo.com', '員工,系統管理者', '2345678', '765432', '345678765', '3', '2', 1, '1,2,3', '1,2,3,4,5,6,7,9,10,12', '2025-02-12 10:09:10', '3v9kgj8pdnb1nb1khsm3vprla0', '2024-10-13 06:33:41'),
(9, '980016', '$2y$10$6Gr5FDgK1rX1FLXIWQu5humkXTg1t62WWvzWBK8PoUABI3m.XVE2K', '翁佳歆', 'test1@demo.com', '員工', '衛教師', '', '', '3', '4', 1, '1,2,3,9', '1,2,3,4,5,6,7,9,10,12,19,20,21', '2025-05-12 08:41:37', '2omu0qnh2uu5tvnlnhjsfvrca6', '2024-10-14 04:33:22'),
(10, '102066', '$2y$10$EqO6cyNoXmVWm4xMmMyb3OWbmvqE.1noaf6Dja9bReMghwT/l0Vmu', '何孟瑾', 'test2@demo.com', '員工', '衛教師', '', '', '3', '4', 1, '1,2,9', '1,2,3,4,5,6,7,9,19,20,21', '2025-05-13 09:28:00', 'bn1t7ana86b3d3c1pkt878ms87', '2024-10-14 04:34:14'),
(11, '111084', '$2y$10$DuUtBvpKCwnOEtk5YpafVO7fL8zafiZfFRlBNC6RXZssE61HcRbN.', '周祈翔', 'test3@demo.com', '員工,系統管理者', '', '', '', '4', '', 1, '1,9,10', '1,2,3,4,19,20,21,24,25', '2025-02-21 11:28:04', '4gmk60nd7qte0eb0h5frsce8c5', '2024-10-14 04:34:49'),
(12, '112142', '$2y$10$pcjlliLDTez1piMx2qWeGepvXl8NUAQNWNAJqBlR2sdBrPw98xFju', '張筱翌', 'test4@demo.com', '員工', '', '', '', '3', '3', 1, '1,9', '1,2,3,4,19,20,21', '2025-02-11 23:46:53', 'c6r1u1p1f5a0gck78pf44neib5', '2024-10-14 04:35:22'),
(13, '112225', '$2y$10$oQc5Fb3DP.WsP4eO0FtSZOXuoj/SwrLcG7uK.bCUSsYibZlmG18we', '葉思賢', 'test5@demo.com', '員工', '', '', '', '3', '3', 1, '1,2,3,9', '1,2,3,4,5,6,7,9,26,10,12,19,20,21', '2024-10-30 10:40:22', '9q2u8c5jskmsfem2lrkjpfrv87', '2024-10-14 04:35:56'),
(16, '101017', '$2y$10$0foBNgx4RcS7qebvofvhNe57IQSKjzxgX/g6Rgb8OMuC9AEVQmDsO', '雷家瑜', 'test8@demo.com', '員工,系統管理者', '', '', '', '3', '3', 1, '1,2,3,9', '1,2,3,4,5,6,7,26,10,12,19,20,21', '0000-00-00 00:00:00', '', '2024-10-25 01:25:14'),
(17, '98072', '$2y$10$u6wr8gP3yiQ.TqNiuIgEB.Dv4XwVWKO7d0674cjDHq10Xg6QYxrnC', '林曉雯', 'wen94qq@gmail.com', '員工', '營養衛教師', '', '', '3', '4', 1, '1,2,3,9', '1,2,3,4,5,6,7,9,26,10,12,19,20', '2025-05-13 13:37:15', 'looi75g2sq4ddi99r998pdaof2', '2024-11-06 00:57:59'),
(18, '101049', '$2y$10$cmEZwhhSLx.47dmNQov6keDDt05yDxTeEx4l2f3Iv6ujrivmvt0xC', '吳宗祐', 'heero.com@ansn.com.tw', '員工,系統管理者', '', '035351200', '', '1', '', 1, '1,2,3,9,10,11', '1,2,3,4,5,6,7,9,26,29,10,12,19,20,21,24,25', '2025-04-11 13:39:56', 'spru0ilkjc7iangcku38jpgfg6', '2024-12-12 05:37:50'),
(19, '113015', '$2y$10$Kyz6o1py20hHWUDc02t4OOYsanLGgZDEzX0/mCccKXjBEVhdsOKR.', '傅喬偉', 'test21@demo.com', '員工,系統管理者', '', '', '', '4', '', 1, '1,2,3,9,10,11', '1,2,3,4,5,6,7,9,26,29,10,12,19,20,21,24,25,32,33', '2024-12-13 13:33:45', 'icbb1b41r2r1nr63nd7di1m0j7', '2024-12-13 05:33:27'),
(20, '110135', '$2y$10$4mtdXr8z1rzo4oNMFB5/U.lATIWjOo2F25qrk0JjDRAQ.oOwbah/u', '李汶傑', '110135@ansn.com.tw', '員工,系統管理者', '資訊', '', '', '4', '', 1, '1,9,10', '1,2,3,4,19,20,21,24,25', '2024-12-13 13:35:32', 'ld9teeajpu9ct251gaej47t4t7', '2024-12-13 05:35:10'),
(21, '113123', '$2y$10$MpOdLC5irvjwrciAh0Xvr.RBt.auGU.RmGLm3ki7Sll167uQgwbma', '卓思辰', 'test10@demo.com', '員工,系統管理者', '', '', '', '4', '', 1, '1,2,3,9,10,11', '1,2,3,4,5,6,7,9,26,29,10,12,19,20,21,24,25,32,33', '2025-04-07 15:22:38', '4jom5blgm70v8s4ceiehht55v7', '2024-12-13 05:37:33'),
(23, '100023', '$2y$10$67rgSS6brFSKmuohEmChyuI.wYon8l4d8eN6yuIf089YX.ujy081m', '廖敏珊', 'test12@demo.com', '員工', '衛教師', '', '', '3', '4', 1, '1,2,3,9', '1,2,3,4,5,6,7,9,10,12,19,20,21', '2025-05-13 09:16:09', 'ne9a658r6hunuunoo3hs4jgsf7', '2024-12-13 05:48:42'),
(24, '102002', '$2y$10$NJ1WpPse86maoNLl4EUX/.O/gP3QcFdyRgnZQ89eozvExftyF6oL.', '吳月君', 'test13@demo.com', '員工', '衛教師', '', '', '3', '4', 1, '1,2,3,9', '1,2,3,4,5,6,7,9,10,12,19,20,21', '2025-05-13 13:38:24', '7loubr7rr21mum6q1qck80uog1', '2024-12-13 05:49:37'),
(25, '99067', '$2y$10$ABoocFvGvEG9A/J34upqVOl5IAOF7tC06.w5Af9A.H9A7slL/klni', '陳靜慧', 'test14@demo.com', '員工', '衛教師', '', '', '3', '4', 1, '1,2,3,9', '1,2,3,4,5,6,7,9,10,12,19,20,21', '2025-05-13 13:29:44', 'bn1t7ana86b3d3c1pkt878ms87', '2024-12-13 05:50:57'),
(26, '111121', '$2y$10$bJgv4WIptuctKMEuzD7htekIiGxvVdbtOoraA5S8LyLE4Xb08oJhu', '楊芷宜', 'test15@demo.com', '員工', '衛教師', '', '', '3', '4', 1, '1,2,3,9', '1,2,3,4,5,6,7,9,10,12,19,20,21', '2025-05-06 15:33:26', 'kv5r2nsao8fiatovqpf2plps10', '2024-12-13 05:52:09'),
(27, '103072', '$2y$10$CPbAwYFdJkjiKUXEfdzDZecsFIerDKAeQ2zWhuZWrYbeh9s9Ar8Ha', '戴秋玉', 'test16@demo.com', '員工', '衛教師', '', '', '3', '4', 1, '1,2,3,9', '1,2,3,4,5,6,7,9,10,12,19,20,21', '2025-05-13 08:50:45', 'uqoc85m6nu7m2v958n3pbnk9i2', '2024-12-13 05:53:02'),
(28, '101047', '$2y$10$zaNta2Xm079c.kSJwnth5OGwJEZ7zZ7oxn9tyG1nPFJdOZ3b2uRWy', '楊惠婷', '101047', '員工,健檢', '', '', '', '3', '4', 1, '1,2,3,9', '1,2,3,4,5,6,7,9,26,29,10,12,19,20,21', '0000-00-00 00:00:00', '', '2024-12-24 06:10:47'),
(29, '106052', '$2y$10$MAxga17JLVAB1WmPFqxX6.iJMS07dx2dSQ2qFwnbpeCkV76T/PuFC', '張基毅', 'test20@demo.com', '員工,系統管理者', '', '', '', '4', '', 1, '1,2,3,9,10,11', '1,2,3,4,5,6,7,9,26,29,10,12,19,20,21,24,25,32,33', '2025-02-21 11:28:15', 'j5bjp4ooaeln04edhkbnj66v56', '2025-02-12 03:18:19'),
(30, '109022', '$2y$10$K7/92PkE5idt9Nc4zlFWN.rkb6SSZBOH.o31.PXDrxdqeahTCFjyq', '吳佩臻', '109022', '員工', '', '', '', '3', '3', 1, '1,2', '1,2,3,4,5,6,7,9,26', '2025-04-17 13:55:57', 'luhqei7rde69g1piqtbetshns4', '2025-04-17 05:30:11');

--
-- 已匯出資料表的索引
--

--
-- 資料表索引 `platform_users`
--
ALTER TABLE `platform_users`
  ADD PRIMARY KEY (`puid`),
  ADD KEY `cmr_account` (`crm_account`);

--
-- 在匯出的資料表使用 AUTO_INCREMENT
--

--
-- 使用資料表 AUTO_INCREMENT `platform_users`
--
ALTER TABLE `platform_users`
  MODIFY `puid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;COMMIT;

