항해99-msa

테이블 (6)

comments (댓글)

  • id (comment_id) — Long — 기본 키 — NOT NULL
  • id (post_id) — Long — 외래 키 → posts.id — NOT NULL
  • content — Stirng
  • writerId — Long
  • CreatedAt — DATETIME
  • UpdatedAt — DATETIME

follows (팔로우)

  • id (follow_id) — Long — 기본 키 — NOT NULL
  • follower — User — 외래 키 → users.id — NOT NULL
  • following — User — 외래 키 → users.id — NOT NULL
  • CreatedAt — DATETIME

likes (좋아요)

  • id (like_id) — Long — 기본 키 — NOT NULL
  • id (post_id) — Long — 외래 키 → posts.id — NOT NULL
  • activity_id — Long

posts (게시물)

  • id (post_id) — Long — 기본 키 — NOT NULL
  • title — String
  • content — String
  • CreatedAt — DATETIME
  • UpdatedAt — DATETIME
  • activity_id — String

stocks (주식)

  • id (stocks) — Long — 기본 키 — NOT NULL
  • market — String
  • opening_price — Double
  • high_price — Double
  • low_price — Double
  • trade_price — Double
  • prev_closing_price — Double
  • change (chage) — Double
  • signed_change_price — Double
  • signed_change_rate (signed_changed_rate) — Double
  • acc_trade_price — Double
  • acc_trade_volume — Double
  • acc_trade_price_24h — Double
  • timestamp

users (사용자)

  • id — BIGINT — 기본 키 — NOT NULL
  • 이름 (username) — varchar2
  • 비밀번호 (password) — varchar2
  • 이메일 (email) — varchar2
  • 한줄 소개 (introduction) — varchar2
  • 이미지 (image) — varchar2
  • 생성 날짜 (CreatedAt) — DATETIME