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