spj_db

Tables (10)

Member (회원)

  • member_id — BIGINT — Primary key — NOT NULL — 회원ID
  • email — VARCHAR(100) — NOT NULL — 이메일
  • password — VARCHAR(255) — NOT NULL — 비밀번호
  • nickname — VARCHAR(50) — NOT NULL — 닉네임
  • created_at — DATETIME — NOT NULL — 생성일
  • current_point — INT(20) — NOT NULL — 보유포인트

attachment

  • file_id — BIGINT(20) — Primary key — NOT NULL
  • post_id — BIGINT(20) — NOT NULL
  • original_name — VARCHAR(255)
  • save_name — VARCHAR(255)
  • file_path — VARCHAR(500)
  • INDEX — `post_id`

category (카테고리)

  • category_id — BIGINT(20) — Primary key — NOT NULL — 카테고리ID
  • name — VARCHAR(50) — NOT NULL — 카테고리 이름

comment (댓글)

  • comment_id — BIGINT(20) — Primary key — NOT NULL
  • post_id — BIGINT(20) — NOT NULL
  • member_id — BIGINT(20) — NOT NULL
  • parent_id — BIGINT(20) — Foreign key → comment.comment_id
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • INDEX — `post_id`
  • INDEX — `member_id`
  • INDEX — `parent_id`

inventory (아이템저장)

  • inventory_id — BIGINT(20) — Primary key — NOT NULL
  • member_id — BIGINT(20) — NOT NULL
  • item_id — BIGINT(20) — NOT NULL
  • is_equipped — TINYINT(1)
  • purchase_date — DATETIME
  • INDEX — `item_id`

item

  • item_id — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • price — INT(11) — NOT NULL
  • description — VARCHAR(255)
  • item_type — VARCHAR(20)
  • css_code — VARCHAR(255)
  • image_url — VARCHAR(255)

point_history (포인트사용내역)

  • history_id — BIGINT(20) — Primary key — NOT NULL
  • member_id — BIGINT(20) — NOT NULL
  • amount — INT(11) — NOT NULL
  • balance_snapshot — INT(11) — NOT NULL
  • reason — VARCHAR(50)
  • created_at — DATETIME
  • INDEX — `member_id`

post (포스트)

  • post_id — BIGINT(20) — Primary key — NOT NULL
  • member_id — BIGINT(20) — NOT NULL
  • category_id — BIGINT(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT(11)
  • is_deleted — TINYINT(1)
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — `member_id`
  • INDEX — `category_id`

post_tag (포스트 태그)

  • post_tag_id — BIGINT(20) — Primary key — NOT NULL
  • post_id — BIGINT(20) — NOT NULL
  • tag_id — BIGINT(20) — NOT NULL
  • INDEX — `post_id`
  • INDEX — `tag_id`

tag (태그)

  • tag_id — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL