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)