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