Aspnet_applications in membership

1. Table Structure
---------------
Field type description

========================================================== ====

Applicationid uniqueidentifier application site no.

---------------------------------------------
Applicationname nvarchar (256) site name

---------------------------------------------
Loweredapplicationname nvarchar (256) site name in lowercase

-------------------------------------------------
Description nvarchar (256) site description

Note: uniqueidentifier ---- indicates the guid data structure, which is expressed by a 36 or 38-Bit String.
The actual storage only occupies 16 bytes. This encoding method is not repeated across the world.
Nvarchar (256)-it is for international purposes.

 

2. Example:
-----------------
Applicationid applicationname loweredapplicationname description
========================================================== ==============================
{87a34093-d3fe-4786-a6d2-fa69de254860}

/Profilesample user configuration example
-----------------------------------------------------------

{C4084E49-EE8D-4E89-931C-38B0B2C43251}

/Testweb test site

3. This table is mainly used to manage the information of multiple sites and point out which site the data belongs. Use the stored procedure.