Guest User

Untitled

a guest
May 25th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. ## User Table
  2. CREATE TABLE [User] (
  3. [User_ID] [int] IDENTITY(1,1) NOT NULL,
  4. [User_Date] [datetime],
  5. [User_Name] [nvarchar](15),
  6. [User_Picture] [nvarchar](255)
  7. )
  8. ## Message Table
  9. CREATE TABLE [Message] (
  10. [Message_ID] [int] IDENTITY(1,1) NOT NULL,
  11. [User_ID] [int],
  12. [User_Recv] [int],
  13. [Message_Body] [nvarchar](140),
  14. [Date_Time] [datetime],
  15. [Flag_Private] [bit],
  16. [Flag_Attachment] [bit],
  17. [Attchment_ID] [int]
  18. )
  19. ## User_Message Table
  20. CREATE TABLE [User_Message] (
  21. [User_Message_ID] [int] IDENTITY(1,1) NOT NULL,
  22. [User_ID] [int],
  23. [Message_ID] [int]
  24. )
  25. ## Attachments Table
  26. CREATE TABLE [Attachments] (
  27. [Attachment_ID] [int] IDENTITY(1,1) NOT NULL,
  28. [Attachment_Binary] [nvarchar](255),
  29. [Attacment_Date] [datetime]
  30. )
  31. ## Followers Table
  32. CREATE TABLE [Followers] (
  33. [Followers_Key] [int] IDENTITY(1,1),
  34. [User_ID] [int],
  35. [Follower_ID] [int]
  36. )
Add Comment
Please, Sign In to add comment