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