citypalcon

Tables (9)

BookMark (bookmark)

  • user_id (userId) — number — Foreign key → User.id — NOT NULL
  • alternatively — number — Foreign key → Sector_Category_Ticker.id — NOT NULL
  • id (id2) — number — Foreign key — NOT NULL

Folder (folder system)

  • id — number — Primary key — NOT NULL
  • user_id (userId) — number — Foreign key → User.id — NOT NULL
  • news_id (newsId) — list — Foreign key → news.uuid — NOT NULL
  • name — string

Sector_Category_Ticker (autocomplete)

  • id — number — Primary key — NOT NULL
  • name — string — NOT NULL
  • sub_name (subName) — string
  • data_type (Field) — string — NOT NULL
  • exchange — striong

Subscription (subscription)

  • id — number — Primary key — NOT NULL
  • paln_id (palnId) — number — Foreign key → palns.id — NOT NULL
  • status — bool — NOT NULL
  • started_at (startedAt) — date — NOT NULL
  • ended_at (endedAt) — date
  • count — number

User (user)

  • id — number — Primary key — NOT NULL
  • name — string — NOT NULL
  • email — string — NOT NULL
  • password — string — NOT NULL
  • subscription — number — Foreign key → Subscription.id — NOT NULL

keyWord (keyword)

  • user_id (userId) — number — Foreign key → User.id — NOT NULL
  • SCT_id (SCTId) — number — Foreign key → Sector_Category_Ticker.id — NOT NULL

news

  • uuid — string — Primary key — NOT NULL
  • publish_time (publishTime) — date — NOT NULL
  • title — string — NOT NULL
  • description — string — NOT NULL
  • url — string — NOT NULL
  • imageUrls — string
  • name — string
  • brand_name (brandName) — string

palns (paln)

  • id — number — Primary key — NOT NULL
  • plan_name (planName) — NOT NULL
  • price — number — NOT NULL

paymentMethod (card)

  • id — number — Primary key — NOT NULL
  • user_id (userId) — number — Foreign key → User.id — NOT NULL
  • masked_cardnum (maksedCardNum) — string
  • card_token (cardToken) — string
  • payment_history (paymentHistory) — date