news
Tables (17)
Kospi (Untitled)
- id (Key) — int — Primary key — NOT NULL
- name (기업 이름) — 16
- cap (마켓 갭) — 16
- price (종가) — 10
- day (하루) — 10
- rank (순위) — int
commodities (Currencies)
- id (Key) — int — Primary key — NOT NULL
- name (지역) — varchar(16)
- price (종가) — varchar(10)
- day (하루) — varchar(10)
- week (일주일) — varchar(10)
- month (한달) — varchar(10)
- kind (종류) — varchar(16)
currencies (Commodities)
- id (Key) — int — Primary key — NOT NULL
- name (상품 이름) — varchar(16)
- price (종가) — varchar(16)
- day (하루) — varchar(10)
- week (일주일) — varchar(10)
- month (한달) — varchar(10)
- kind (상품 종류) — varchar(16)
etfs (Top Mover(ETF))
- id (Key) — int — Primary key — NOT NULL
- name (이름) — varchar(16)
- price (종가) — varchar(10)
- change (변화) — varchar(10)
- volume (폭) — varchar(10)
- average (평균) — varchar(10)
indicator_categories (Untitled6)
- id (Key) — int — Primary key — NOT NULL
- main (메인) — varchar(32)
- cateroies (카테고리) — varchar(32)
indicators (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- id (Key2) — int — Foreign key → indicator_categories.id — NOT NULL
- country (나라) — varchar(32)
- last (종가) — varchar(32)
- prev (이전) — varchar(32)
- reference (날짜) — varchar(32)
- Field
indices (Global Indices)
- id (Key) — int — Primary key — NOT NULL
- name (이름) — varchar(32)
- price (종가) — varchar(16)
- day (하루) — varchar(10)
- week (일주일) — varchar(10)
- month (한달) — varchar(10)
insights (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- kind (사진 종류) — varchar(32)
- image_path (스크린샷) — varchar(128)
nasdaq (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- name (이름) — 16
- price (종가) — 10
- three_m (3달) — 10
- six_m (6달) — 10
- year (1년) — 10
- rank (순위) — int
news (Untitled8)
- id (key) — int — Primary key — NOT NULL
- title (제목) — string
- link_url (기사 링크) — string
- image (이미지 주소) — string
- sector (면) — number
- kind (뉴스 종류) — string
sectors (Global Sectors)
- id (Key) — int — Primary key — NOT NULL
- country (국가) — varchar(16)
- name (지수 이름) — varchar(32)
- day (하루) — varchar(10)
- week (일주일) — varchar(10)
- month (한달) — varchar(10)
subscribe (Untitled9)
- id (Key) — int — Primary key — NOT NULL
- access (구독 유무) — boolean
- stated_date (시작 일자) — dateTime
- finish_date (종료 일자) — dateTime
today (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(64)
- referance (참고날짜) — varchar(64)
- value (가치) — varchar(32)
- previous (이전) — var(32)
- unit (유닛) — var(32)
usActives (US Stock Market Most Actives)
- id (Key) — int — Primary key — NOT NULL
- name (이름) — 16
- price (종가) — 10
- change (변화) — 10
- volume (폭) — 10
- volume_avg (평균) — 10
- rank (순위) — int
usGainers (US Stock Day Gainers)
- id (Key) — int — Primary key — NOT NULL
- name (이름) — 16
- price (종가) — 10
- change (변화) — 10
- volume (폭) — 10
- rank (순위) — int
users (Untitled7)
- id (Key) — int — Primary key — NOT NULL
- username (아이디) — varchar(32)
- password (비밀번호) — varchar(128)
- role (역할) — enum('user', 'admin')
- subscribe_id (구독 아이디) — int — Foreign key → subscribe.id — NOT NULL
wgbs (World Government Bonds)
- id (Key) — int — Primary key — NOT NULL
- country (나라) — varchar(16)
- Yield (생산) — varchar(10)
- Prev (이전) — varchar(10)
- High (최고) — varchar(10)
- Low (최저) — varchar(10)
- change (변화) — varchar(10)
- year (년) — varchar(10)