project3

Tables (9)

CryptoPrice (Untitled9)

  • ID (PriceID) — SERIAL — Primary key — NOT NULL
  • date (Field) — DATE
  • Open (시가) — NUMERIC(20,2)
  • High (고가) — NUMERIC(20,2)
  • Low (저가) — NUMERIC(20,2)
  • Close (종가) — NUMERIC(20,2)
  • Volume (거래량) — NUMERIC(30,2)

Currency (Untitled8)

  • ID (통화 ID) — SERIAL — Primary key — NOT NULL
  • CODE (통화명(USD, KOR)) — VARCHAR(10)

Exchange (Untitled7)

  • ID (거래소 ID) — SERIAL — Primary key — NOT NULL
  • NAME (거래소 이름) — VARCHAR(50)

Forex (Untitled)

  • ID (대상 통화 ID) — Primary key — NOT NULL
  • Currency_name (통화 이름) — SERIAL
  • DATE (날짜) — TimeStamptz
  • Open (개장 환율 가격) — Decimal(5,2)
  • High (가장 높은 환율) — Decimal(5,2)
  • Low (낮은 환율) — Decimal(5,2)
  • Close (환율 종가) — Decimal(5,2)

Holding (Untitled6)

  • ID (Key) — SERIAL — Primary key — NOT NULL
  • tickerid (Field) — INTEGER
  • weight (Field2) — NUMERIC(5,3)

Sector (Untitled3)

  • ID (Key) — SERIAL — Primary key — NOT NULL
  • indexid (Field) — INTEGER
  • tickerid (Field3) — INTEGER
  • NAME (Field2) — VARCHAR(50)

StockPrice (Untitled5)

  • ID (Key) — SERIAL — Primary key — NOT NULL
  • tickerid (Field) — INTEGER
  • Open (시가) — NUMERIC(15,6)
  • High (고가) — NUMERIC(15,6)
  • Low (저가) — NUMERIC(15,6)
  • Close (종가) — NUMERIC(15,6)
  • Volume (거래량) — BIGINT

Tickers (Untitled2)

  • ID (티커 아이디) — SERIAL — Primary key — NOT NULL
  • NAME (이름) — VARCHAR(100)

index (Untitled4)

  • ID (Key) — SERIAL — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(100)