test

Tables (18)

Cart

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

CartItem

  • id — BIGINT — Primary key — NOT NULL
  • cart_id — BIGINT — Foreign key → Cart.id — NOT NULL
  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_cartitem_product`

Category

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • parent_id — BIGINT — Foreign key → Category.id
  • display_order — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_category_name`
  • INDEX — `idx_category_parent`

Comment

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → Post.id — NOT NULL
  • author_id — BIGINT — Foreign key → User.id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → Comment.id
  • content — TEXT — NOT NULL
  • like_count — INT — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_comment_post`
  • INDEX — `idx_comment_author`
  • INDEX — `idx_comment_parent`

Delivery

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → Order.id — NOT NULL
  • tracking_number — VARCHAR(100)
  • courier_company — VARCHAR(100)
  • status — VARCHAR(50) — NOT NULL
  • shipped_at — DATETIME
  • delivered_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_delivery_tracking`
  • INDEX — `idx_delivery_status`

Order

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • order_number — VARCHAR(50) — NOT NULL
  • total_price — DECIMAL(12,2) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • delivery_address — VARCHAR(500) — NOT NULL
  • delivery_phone — VARCHAR(20) — NOT NULL
  • delivery_memo — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_order_user`
  • INDEX — `idx_order_status`
  • INDEX — `idx_order_date`

OrderItem

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → Order.id — NOT NULL
  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • product_name — VARCHAR(255) — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — DECIMAL(10,2) — NOT NULL
  • total_price — DECIMAL(12,2) — NOT NULL
  • INDEX — `idx_orderitem_order`
  • INDEX — `idx_orderitem_product`

Payment

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → Order.id — NOT NULL
  • payment_method — VARCHAR(50) — NOT NULL
  • amount — DECIMAL(12,2) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • transaction_id — VARCHAR(255)
  • paid_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_payment_order`
  • INDEX — `idx_payment_status`

Post

  • id — BIGINT — Primary key — NOT NULL
  • author_id — BIGINT — Foreign key → User.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT — NOT NULL
  • like_count — INT — NOT NULL
  • comment_count — INT — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_post_author`
  • INDEX — `idx_post_created`
  • INDEX — `idx_post_title`

PostImage

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → Post.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • alt_text — VARCHAR(255)
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_postimage_post`

PostLike

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → Post.id — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_postlike_user`

Product

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10,2) — NOT NULL
  • stock_quantity — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_product_name`
  • INDEX — `idx_product_price`
  • INDEX — `idx_product_active`

ProductCategory

  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • category_id — BIGINT — Foreign key → Category.id — NOT NULL

ProductImage

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • alt_text — VARCHAR(255)
  • display_order — INT — NOT NULL
  • is_main — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_product_image_product`
  • INDEX — `idx_product_image_order`

Report

  • id — BIGINT — Primary key — NOT NULL
  • reporter_id — BIGINT — Foreign key → User.id — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — VARCHAR(100) — NOT NULL
  • description — TEXT
  • status — VARCHAR(50) — NOT NULL
  • admin_memo — TEXT
  • processed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_report_reporter`
  • INDEX — `idx_report_target`
  • INDEX — `idx_report_status`

SocialAccount

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_social_user`

User

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(20)
  • address — VARCHAR(500)
  • role — VARCHAR(50) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • email_verified — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — `idx_user_email`
  • INDEX — `idx_user_nickname`

Wishlist

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_wishlist_product`