You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1 lines
3.9 KiB
1 lines
3.9 KiB
<table border=1><tr><td colspan=2>名稱</td><td colspan=2>otb_role</td></tr><tr><td>序號</td><td>欄位代號</td><td>欄位說明</td><td>型態</td><td>長度</td><td>鍵</td><td>可為Null</td><td>備註</td></tr><tr><td>1</td><td>guid</td><td></td><td>char</td><td>36</td><td>PK</td><td>NO</td><td>唯一,預設值:(newid())</td></tr><tr><td>2</td><td>create_user_guid</td><td></td><td>char</td><td>36</td><td>FK</td><td>YES</td><td>FK(名稱FK_tb_role_tb_user_create_user,對應欄位otb_user.guid)</td></tr><tr><td>3</td><td>modify_user_guid</td><td></td><td>char</td><td>36</td><td>FK</td><td>YES</td><td>FK(名稱FK_tb_role_tb_user_modify_user,對應欄位otb_user.guid)</td></tr><tr><td>4</td><td>active_flag</td><td></td><td>char</td><td>1</td><td></td><td>NO</td><td>預設值:('Y')</td></tr><tr><td>5</td><td>create_date</td><td></td><td>datetime</td><td></td><td></td><td>NO</td><td>預設值:(getdate())</td></tr><tr><td>6</td><td>modify_date</td><td></td><td>datetime</td><td></td><td></td><td>NO</td><td>預設值:(getdate())</td></tr><tr><td>7</td><td>role_id</td><td></td><td>varchar</td><td>16</td><td></td><td>YES</td><td></td></tr></table><br/><table border=1><tr><td colspan=2>名稱</td><td colspan=2>otb_user</td></tr><tr><td>序號</td><td>欄位代號</td><td>欄位說明</td><td>型態</td><td>長度</td><td>鍵</td><td>可為Null</td><td>備註</td></tr><tr><td>1</td><td>guid</td><td></td><td>char</td><td>36</td><td>PK</td><td>NO</td><td>唯一,預設值:(newid())</td></tr><tr><td>2</td><td>role_guid</td><td></td><td>char</td><td>36</td><td>FK</td><td>YES</td><td>FK(名稱FK_tb_user_tb_role,對應欄位otb_role.guid)</td></tr><tr><td>3</td><td>create_user_guid</td><td></td><td>char</td><td>36</td><td>FK</td><td>YES</td><td>FK(名稱FK_tb_user_tb_user_create_user,對應欄位otb_user.guid)</td></tr><tr><td>4</td><td>modify_user_guid</td><td></td><td>char</td><td>36</td><td>FK</td><td>YES</td><td>FK(名稱FK_tb_user_tb_user_modify_user,對應欄位otb_user.guid)</td></tr><tr><td>5</td><td>active_flag</td><td></td><td>char</td><td>1</td><td></td><td>NO</td><td>預設值:('Y')</td></tr><tr><td>6</td><td>create_date</td><td></td><td>datetime</td><td></td><td></td><td>NO</td><td>預設值:(getdate())</td></tr><tr><td>7</td><td>email</td><td></td><td>varchar</td><td>64</td><td></td><td>YES</td><td></td></tr><tr><td>8</td><td>mobile</td><td></td><td>varchar</td><td>15</td><td></td><td>YES</td><td></td></tr><tr><td>9</td><td>modify_date</td><td></td><td>datetime</td><td></td><td></td><td>NO</td><td>預設值:(getdate())</td></tr><tr><td>10</td><td>tel</td><td></td><td>varchar</td><td>20</td><td></td><td>YES</td><td></td></tr><tr><td>11</td><td>user_id</td><td></td><td>nvarchar</td><td>16</td><td></td><td>NO</td><td></td></tr><tr><td>12</td><td>user_name</td><td></td><td>nvarchar</td><td>32</td><td></td><td>YES</td><td></td></tr></table><br/><table border=1><tr><td colspan=2>名稱</td><td colspan=2>otb_session</td></tr><tr><td>序號</td><td>欄位代號</td><td>欄位說明</td><td>型態</td><td>長度</td><td>鍵</td><td>可為Null</td><td>備註</td></tr><tr><td>1</td><td>guid</td><td></td><td>char</td><td>36</td><td>PK</td><td>NO</td><td>唯一,預設值:(newid())</td></tr><tr><td>2</td><td>create_user_guid</td><td></td><td>char</td><td>36</td><td>FK</td><td>YES</td><td>FK(名稱FK_otb_session_tb_user_create_user,對應欄位otb_user.guid)</td></tr><tr><td>3</td><td>modify_user_guid</td><td></td><td>char</td><td>36</td><td>FK</td><td>YES</td><td>FK(名稱FK_otb_session_tb_user_modify_user,對應欄位otb_user.guid)</td></tr><tr><td>4</td><td>active_flag</td><td></td><td>char</td><td>1</td><td></td><td>NO</td><td>預設值:('Y')</td></tr><tr><td>5</td><td>create_date</td><td></td><td>datetime</td><td></td><td></td><td>NO</td><td>預設值:(getdate())</td></tr><tr><td>6</td><td>modify_date</td><td></td><td>datetime</td><td></td><td></td><td>NO</td><td>預設值:(getdate())</td></tr></table><br/>
|