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