Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ## User Table
- CREATE TABLE [User] (
- [User_ID] [int] IDENTITY(1,1) NOT NULL,
- [User_Date] [datetime],
- [User_Name] [nvarchar](15),
- [User_Picture] [nvarchar](255)
- )
- ## Message Table
- CREATE TABLE [Message] (
- [Message_ID] [int] IDENTITY(1,1) NOT NULL,
- [User_ID] [int],
- [User_Recv] [int],
- [Message_Body] [nvarchar](140),
- [Date_Time] [datetime],
- [Flag_Private] [bit],
- [Flag_Attachment] [bit],
- [Attchment_ID] [int]
- )
- ## User_Message Table
- CREATE TABLE [User_Message] (
- [User_Message_ID] [int] IDENTITY(1,1) NOT NULL,
- [User_ID] [int],
- [Message_ID] [int]
- )
- ## Attachments Table
- CREATE TABLE [Attachments] (
- [Attachment_ID] [int] IDENTITY(1,1) NOT NULL,
- [Attachment_Binary] [nvarchar](255),
- [Attacment_Date] [datetime]
- )
- ## Followers Table
- CREATE TABLE [Followers] (
- [Followers_Key] [int] IDENTITY(1,1),
- [User_ID] [int],
- [Follower_ID] [int]
- )
Add Comment
Please, Sign In to add comment