spj_db1
Tables (10)
attachment
- file_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- original_name — VARCHAR(255)
- save_name — VARCHAR(255)
- file_path — VARCHAR(500)
category
- category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
comment
- comment_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- parent_id — BIGINT — Foreign key → comment.comment_id
- content — TEXT — NOT NULL
- created_at — DATETIME
inventory
- inventory_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- item_id — BIGINT — Foreign key → item.item_id — NOT NULL
- is_equipped — BOOLEAN
- purchase_date — DATETIME
item
- item_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- price — INT — NOT NULL
- description — VARCHAR(255)
- item_type — VARCHAR(20)
- css_code — VARCHAR(255)
- image_url — VARCHAR(255)
member
- member_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- current_point — INT — NOT NULL
- created_at — DATETIME
point_history
- history_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- amount — INT — NOT NULL
- balance_snapshot — INT — NOT NULL
- reason — VARCHAR(50)
- created_at — DATETIME
post
- post_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- category_id — BIGINT — Foreign key → category.category_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
post_tag
- post_tag_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
tag
- tag_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL