Muffin Erd
Tables (8)
Asset (회원보유주식)
- asset_id (PK) — LONG — Primary key — NOT NULL
- purchase_price (Field) — INT
- share_count (Field2) — INT
- total_asset (Field3) — INT
- total_profit (Field4) — INT
- total_profit_ratio (Field5) — INT
- transaction_date (Field6) — VARCHAR
- transaction_type (Field7) — VARCHAR
- user_id (FK) — LONG — Foreign key → User.user_id — NOT NULL
- stock_id (FK2) — LONG — Foreign key → Stock.stock_id — NOT NULL
Board (게시글)
- board_id (PK) — LONG — Primary key — NOT NULL
- board_title (Field) — VARCHAR
- board_content (Field2) — VARCHAR(9000)
- board_regdate (Field3) — VARCHAR
- view_cnt (Field4) — INT
- user_id (FK) — LONG — Foreign key → User.user_id — NOT NULL
Comment (댓글)
- comment_id (PK) — LONG — Primary key — NOT NULL
- comment_content (Field) — VARCHAR
- comment_regdate (Field2) — VARCHAR
- board_id (FK) — LONG — Foreign key → Board.board_id — NOT NULL
- user_id (PK2) — LONG — Foreign key → User.user_id — NOT NULL
InvestProfile (투자프로필)
- invest_profile_id (PK) — LONG — Primary key — NOT NULL
- investment_period (Field) — VARCHAR
- investment_propensity (Field2) — VARCHAR
- user_id (FK) — LONG — Foreign key → User.user_id — NOT NULL
News (뉴스)
- news_id (PK) — LONG — Primary key — NOT NULL
- news_regdate (Field) — VARCHAR
- news_title (Field2) — VARCHAR
- news_content (Field3) — VARCHAR(8000
- news_link (Field4) — VARCHAR(8000)
- news_thumbnail (Field5) — VARCHAR(8000)
Stock (주식)
- stock_id (PK) — LONG — Primary key — NOT NULL
- symbol (Field) — VARCHAR
- stock_name (Field2) — VARCHAR
Transaction (거래내역)
- transaction_id (PK) — LONG — Primary key — NOT NULL
- stock_name (Field) — VARCHAR
- money (Field2) — VARCHAR
- transaction_date (Field3) — VARCHAR
- transaction_type (Field4) — VARCHAR
- total_asset (Field5) — INT
- user_id (Field6) — LONG
User (회원)
- user_id (PK) — LONG — Primary key — NOT NULL
- email_id (Field) — VARCHAR
- password (Field2) — VARCHAR
- nickname (Field3) — VARCHAR
- name (Field4) — VARCHAR