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