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