Database Arquitecture part II

To be implemented later, when ready to start

bellow a few ideas

ORDERS

• [ID].[User] FK ([ID].[User]) (USERS)
• [ID].[URL] FK ([ID].[URL]) ([URLS])
• [DEF].[URLS].[Kind].[Action] FK
• [ID].[ORDERS] PK
• [ORDERS].[HYBRID] Bit NULL nullable
  • NULL, then so order only for [URL]
  • FALSE, then so order only for [URL_Mobile]
  • TRUE, then, so order will execute both Dekstop & Mobile url’s
• [ORDERS].[Created] Datetime2
• [Amount] Int

[PURCHASES]

• [ID].[User] FK ([ID].[User]) (USERS)

• [ID].[ORDERS] FK ([ID].[Order]) (ORDERS) NON UNIQUE
• [ID].[Purchase] PK int UNIQUE FROM (ID_USER & ID_ORDER)

[PURCHASES].[MONEY]

• [ID].[Purchase] FK
• [Money]
• [Currency] Char(3)

[Identifier tables]

If using FK’s must be only FK’s from[DEF].Tables

[DEF].[URLS].[Kind]

:: Must be, in order to derive actions based on these

• [ID].[DEF].[Kind] PK
• [DEF].[URLS].[Kind].[Name]
  • Example: Youtube, twitch, kick, and newer kinds that may appear over the time

[DEF].[URLS].[Kind].[Action]

• [ID].[DEF].[Kind] FK
• [ID].[DEF].[URLS].[Kind].[Action] PK TinyInt
• [ID].[DEF].[URLS].[Kind].[Action].[Name] NVarChar(33)
  • Example: Play, Like, Unlike Comment, and other that may come to kind

[DEF].[PRICES].[URLS]

[DEF].[PRICES].[URLS].[PACKS]

[DEF].[PRICES].[URLS].[PACKS].[ACTIONS]

[DEF].[PRICES].[URLS].[PACKS].[ACTIONS]

[DEF].[PRICES].[URLS].[PACKS].[ACTIONS].[Price]