청약톡

테이블 (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)