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)