555

Tables (8)

Asset (Untitled6)

  • asset_id (Key) — Primary key — NOT NULL
  • total_asset (Field)
  • transaction_date (Field2)
  • share_count (Field3)
  • transaction_type (Field4)
  • purchase_price (Field5)
  • person_id (Key2) — LONG — Foreign key → User.user_id — NOT NULL — 어드민과 회원은 일련번호 시작 알파벳 차이로 구분
  • stock_id (Key3) — LONG — Foreign key → Stock.stock_id — NOT NULL

Board (Untitled)

  • board_id (Key) — LONG — Primary key — NOT NULL
  • board_title (Field) — VARCHAR
  • board_content (Field2) — VARCHAR
  • board_regdate (Field3) — DATE
  • person_id (Key2) — LONG — Foreign key → User.user_id — NOT NULL — 어드민과 회원은 일련번호 시작 알파벳 차이로 구분

Comment (Untitled7)

  • comment_id (Key) — LONG — Primary key — NOT NULL
  • person_id (Key2) — LONG — Foreign key → User.user_id — NOT NULL — 어드민과 회원은 일련번호 시작 알파벳 차이로 구분
  • board_id (Key3) — LONG — Foreign key → Board.board_id — NOT NULL
  • comment_regdate (Field) — DATE
  • comment_content (Field2) — VARCHAR

File (Untitled9)

  • file_id (Key) — Primary key — NOT NULL
  • file (Field)
  • image (Field2)

InvestProfile (Untitled8)

  • invest_profile_id (Key) — Primary key — NOT NULL
  • investment_period (Field)
  • investment_propensity (Field2)
  • person_id (Key2) — LONG — Foreign key → User.user_id — NOT NULL — 어드민과 회원은 일련번호 시작 알파벳 차이로 구분

News (Untitled5)

  • news_id (Key) — LONG — Primary key — NOT NULL
  • news_title (Field2) — VARCHAR
  • news_regdate (Field3) — DATE
  • saved (Field6) — INT
  • news _link (Field7)

Stock (Untitled2)

  • stock_id (Key) — LONG — Primary key — NOT NULL
  • symbol (Field) — INT
  • market (Field2) — VARCHAR — 업종코드
  • stock_name (Field3) — VARCHAR — 업종
  • category_code (Field4) — INT
  • category (Field5) — VARCHAR — 자본금(원)

User (Untitled4)

  • user_id (Key) — LONG — Primary key — NOT NULL — 어드민과 회원은 일련번호 시작 알파벳 차이로 구분
  • email_id (Field) — VARCHAR
  • password (Field2) — VARCHAR
  • nickname (Field4) — VARCHAR
  • name (Field5) — VARCHAR