청약톡
테이블 (3)
CORP_INFO (고유번호)
- corp_code (Key) — varchar(8) — 기본 키 — NOT NULL
- stock_code (Field) — varchar(6)
- corp_name (Field2) — varchar(500)
- corp_eng_name (Field3) — varchar(500)
- created_on (Field4) — timestamp
- modified_on (Field5) — timestamp
Subs_corp (상장회사)
- corp_code (Key) — varchar(8) — 기본 키 — NOT NULL
- stock_corp_name (Field2) — varchar(200)
- hold_qnt (Field3) — long
- hold_amt (Field) — long
Subs_info (청약일정)
- corp_code (Key) — varchar(8) — 기본 키 — NOT NULL
- mkt_dcd (Field10) — vharchar(1)
- subs_start_dt (Field2) — varchar(8)
- subs_end_dt (Field3) — varchar(8)
- paym_dt (Field4) — varchar(8)
- allot_dt (Field5) — vahrchar(8)
- iss_qnt (Field6) — long
- iss_amt (Field8) — long
- fv (Field7) — long
- iss_prc (Field9) — long
- corp_name (Field) — varchar(200)