showmeyourticker

Tables (9)

Company

  • company_id — NUMBER — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • is_public — BOOLEAN — NOT NULL
  • industry — VARCHAR

Financial_statements

  • statement_id — NUMBER — Primary key — NOT NULL
  • company_id — Foreign key → Company.company_id — NOT NULL
  • reporting_period — VARCHAR — NOT NULL
  • statement_type — ENUM — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

boards

  • board_id — NUMBER — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

financial_statement_items

  • item_id — NUMBER — Primary key — NOT NULL
  • statement_id — NUMBER — Foreign key → Financial_statements.statement_id — NOT NULL
  • item_name — VARCHAR — NOT NULL
  • item_value — DECIMAL(15,2) — NOT NULL

posts

  • post_id — NUMBER — Primary key — NOT NULL
  • title — VARCHAR — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • board_id — NUMBER — Foreign key → boards.board_id — NOT NULL
  • user_id — NUMBER — Foreign key → users.user_id — NOT NULL

replies

  • reply_id — NUMBER — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • user_id — NUMBER — Foreign key → users.user_id — NOT NULL
  • post_id — NUMBER — Foreign key → posts.post_id — NOT NULL

user-company (user_company)

  • id — NUMBER — Foreign key → users.user_id — NOT NULL
  • company_id — Foreign key → Company.company_id — NOT NULL

user_profiles

  • profile_id — NUMBER — Primary key — NOT NULL
  • user_id — NUMBER — Foreign key → users.user_id — NOT NULL
  • profile_picture_path — VARCHAR
  • phone — VARCHAR
  • address — VARCHAR
  • occupation — VARCHAR
  • bio — TEXT
  • birth — DATE

users

  • user_id — NUMBER — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • email — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL