pg2

Tables (7)

company_info

  • company_code — VARCHAR(20)
  • company_name — VARCHAR(100) — NOT NULL
  • industry — VARCHAR(50)
  • revenue — DECIMAL(15,2)
  • net_profit — DECIMAL(15,2)
  • per — DECIMAL(10,2)

crawling_info

  • crawling_id — SERIAL
  • ipo_code — VARCHAR(20) — NOT NULL
  • url — VARCHAR(255) — NOT NULL
  • update_date — DATE — NOT NULL

ipo_info

  • ipo_code — VARCHAR(20)
  • company_code — VARCHAR(20) — NOT NULL
  • market — VARCHAR(10)
  • total_shares — INTEGER
  • public_subscription_ratio_min — DECIMAL(5,2)
  • public_subscription_ratio_max — DECIMAL(5,2)
  • deposit_rate — DECIMAL(5,2)
  • hope_price_min — DECIMAL(10,2)
  • hope_price_max — DECIMAL(10,2)
  • fixed_price — DECIMAL(10,2)
  • face_value — DECIMAL(10,2)
  • institutional_competition_rate — DECIMAL(10,2)
  • total_competition_rate — DECIMAL(10,2)
  • proportional_competition_rate — DECIMAL(10,2)

ipo_schedule

  • ipo_code — VARCHAR(20)
  • approval_date — DATE
  • demand_forecast_start — DATE
  • demand_forecast_end — DATE
  • subscription_start — DATE
  • subscription_end — DATE
  • allotment_date — DATE
  • listing_date — DATE

ipo_underwriter

  • ipo_code — VARCHAR(20)
  • underwriter_id — INTEGER

underwriter

  • underwriter_id — SERIAL
  • underwriter_name — VARCHAR(100) — NOT NULL

user_notification

  • notification_id — SERIAL
  • user_id — INTEGER — NOT NULL
  • ipo_code — VARCHAR(20) — NOT NULL
  • email_notification — BOOLEAN — NOT NULL
  • calendar_add — BOOLEAN — NOT NULL