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 (삭제일)