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