stocknote
Tables (3)
Stock (주식종목)
- stock_id (종목id) — NOTNULL — Primary key — NOT NULL
- name (종목이름) — NOTNULL
- code (종목코드) — NOTNULL
- market (코스피,코스닥) — NOTNULL
- price (전일종가) — NOTNULL
- created_at (생성일)
- modified_at (수정일)
- deleted_at (삭제일)
StockNote (매매일지)
- stocknote_id (매매일지id) — NOTNULL — Primary key — NOT NULL
- title (제목) — NOTNULL
- content (내용) — NOTNULL
- image (사진)
- user_id (회원id) — NOTNULL — Foreign key → User.user_id — NOT NULL
- stock_id (종목id) — NOTNULL — Foreign key → Stock.stock_id — NOT NULL
- created_at (생성일)
- modified_at (수정일)
- deleted_at (삭제일)
User (회원)
- user_id (회원id) — NOTNULL — Primary key — NOT NULL
- user_nickname (닉네임) — NOTNULL
- password (비밀번호) — NOTNULL
- profile (프로필사진)
- member_role (권한) — NOTNULL
- created_at (가입일)
- modified_at (수정일)
- deleted_at (삭제일)