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