Goopi_최종본

테이블 (19)

bank_account

  • bank_account_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • currency — VARCHAR(10) — NOT NULL
  • bank_name — VARCHAR(100) — NOT NULL
  • country — VARCHAR(100) — NOT NULL
  • account_number — VARCHAR(100) — NOT NULL
  • account_holder — VARCHAR(100) — NOT NULL
  • copy_file_url — VARCHAR(255)
  • updated_at — DATETIME

board_post

  • board_post_id — INT — 기본 키 — NOT NULL
  • user_id (user_id2) — INT — 외래 키 → users.user_id — NOT NULL
  • type — ENUM('FREE', 'NOTICE', 'INQUIRY') — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT
  • created_at — DATETIME

cart

  • cart_id — INT — 기본 키 — NOT NULL
  • user_id (user_id2) — INT — 외래 키 → users.user_id — NOT NULL
  • products_id — INT — 외래 키 → products.products_id — NOT NULL
  • quantity — INT — NOT NULL
  • added_at — DATETIME

chat_message

  • chat_message_id — INT — 기본 키 — NOT NULL
  • chat_room_id — INT — 외래 키 → chat_room.chat_room_id — NOT NULL
  • room_id — INT
  • sender_id — INT
  • message — TEXT
  • read — BOOLEAN — NOT NULL
  • sent_at — DATETIME

chat_room

  • chat_room_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • created_at — DATETIME

delivery_addresses

  • delivery_addresses_Id — VARCHAR(255) — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • label — VARCHAR(100)
  • receiver_name — VARCHAR(100)
  • address — VARCHAR(255)
  • phone — VARCHAR(20)
  • memo — TEXT
  • is_default — BOOLEAN — NOT NULL
  • created_at — DATETIME

follow

  • follow_id — INT — 기본 키 — NOT NULL
  • follower_id — INT — NOT NULL — UNIQUE
  • following_id — INT — NOT NULL — UNIQUE
  • created_at — DATETIME
  • notification_enabled — BOOLEAN — NOT NULL — 신작 알림 여부

order_items

  • order_items_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • products_id — INT — 외래 키 → products.products_id — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — INT — NOT NULL

orders

  • orders_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • status — ENUM('PENDING', 'PAID', 'CANCELED', 'RETURNED') — NOT NULL
  • total_price — INT — NOT NULL
  • delivery_address_id — INT — NOT NULL
  • ordered_at — DATETIME

post

  • post_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT
  • image_url — VARCHAR(255)
  • created_at — DATETIME

products

  • products_id — INT — 기본 키 — NOT NULL
  • seller_id — INT — 외래 키 → users.user_id — NOT NULL — 상품 등록한 판매자 ID
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL
  • stock — INT — NOT NULL
  • category — VARCHAR(100)
  • thumbnail_url — VARCHAR(255)
  • status — ENUM('ON_SALE', 'SOLD_OUT') — NOT NULL — 판매중
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

review

  • review_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL — UNIQUE
  • products_id — INT — 외래 키 → products.products_id — NOT NULL — UNIQUE
  • rating — INT — NOT NULL
  • content — TEXT
  • created_at — DATETIME

settlement

  • settlement_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • total_amount — INT — NOT NULL
  • period_start — DATE
  • period_end — DATE
  • fee — INT — NOT NULL
  • status — ENUM('PENDING', 'COMPLETED') — NOT NULL
  • created_at — DATETIME

settlement_details

  • settlement_detail_id — INT — 기본 키 — NOT NULL
  • orders_id — INT — 외래 키 → orders.orders_id — NOT NULL
  • settlement_id — INT — 외래 키 → settlement.settlement_id — NOT NULL
  • type — ENUM('PRODUCT', 'FEE') — NOT NULL
  • amount — INT — NOT NULL
  • description — TEXT

stats

  • stats_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • seller_id — INT
  • date — DATE
  • total_sales — INT
  • total_profit — INT
  • new_orders — INT
  • completed_orders — INT
  • wish_count — INT
  • new_reviews — INT

store_profiles

  • idstore_profiles_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • store_name — VARCHAR(100) — NOT NULL
  • business_number — VARCHAR(50)
  • introduction — TEXT
  • profile_image_url — VARCHAR(255)
  • agreed_to_terms — BOOLEAN — NOT NULL
  • created_at — DATETIME

user_security

  • user_security_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • otp_secret — VARCHAR(255) — OTP 시크릿 키
  • otp_verified — BOOLEAN — NOT NULL
  • last_verified_at — DATETIME

users

  • user_id — INT — 기본 키 — NOT NULL
  • username — VARCHAR(30) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL — UNIQUE
  • phone — VARCHAR(20) — NOT NULL — UNIQUE
  • role — ENUM('SELLER', 'BUYER') — NOT NULL — 'SELLER', 'BUYER'
  • gender — ENUM('MALE', 'FEMALE') — NOT NULL
  • first_name — VARCHAR(30) — NOT NULL
  • last_name — VARCHAR(30) — NOT NULL
  • country — VARCHAR(100) — NOT NULL
  • city — VARCHAR(100) — NOT NULL
  • zipcode — VARCHAR(20) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • social_provider — ENUM('KAKAO', 'NAVER', 'GOOGLE')
  • social_id — VARCHAR(100) — UNIQUE

wishlist

  • wishlist_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • products_id — INT — 외래 키 → products.products_id — NOT NULL
  • created_at — DATETIME