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
1.1 KiB
1 lines
1.1 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>
|