mall-erd
Tables (11)
ad (광고)
- id (광고 ID) — BIGSERIAL — Primary key — NOT NULL
- user_id (회원 ID) — BIGINT — Foreign key → user.id — NOT NULL
- title (광고제목) — VARCHAR(100)
- description (광고설명) — TEXT
- thumbnail_url (썸네일 경로) — VARCHAR(255)
- status (광고승인상태) — VARCHAR(20)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
ad_video (광고 영상)
- id (광고 영상 ID) — BIGSERIAL — Primary key — NOT NULL
- ad_id (광고 ID) — BIGINT — Foreign key → ad.id — NOT NULL
- video_url (영상 경로) — VARCHAR(255)
- created_at (생성일시) — TIMESTAMP
inquiry (고객지원)
- id (고객지원 ID) — BIGSERIAL — Primary key — NOT NULL
- user_id (회원 ID) — BIGINT — Foreign key → user.id — NOT NULL
- admin_id (관리자 ID) — BIGINT — Foreign key → user.id — NOT NULL
- title (문의 제목) — VARCHAR(100)
- content (문의 내용) — TEXT
- answer (관리자 답변) — TEXT
- status (상태) — VARCHAR(20)
- answered_at (답변일시) — TIMESTAMP
- created_at (생성일시) — TIMESTAMP
notice (공지사항)
- id (공지사항 ID) — BIGSERIAL — Primary key — NOT NULL
- admin_id (관리자 ID) — BIGINT — Foreign key → user.id — NOT NULL
- title (제목) — VARCHAR(255)
- content (내용) — TEXT
- status (상태) — VARCHAR(20)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
order_item (주문 아이템)
- id (주문 아이템 ID) — BIGSERIAL — Primary key — NOT NULL
- order_id (주문 ID) — BIGINT — Foreign key → orders.id — NOT NULL
- product_id (상품 ID) — BIGINT — Foreign key → product.id — NOT NULL
- quantity (수량) — INT
- price (단가) — BIGINT
- subtotal (소계) — BIGINT
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
- deleted_at (삭제일시) — TIMESTAMP
orders (주문)
- id (주문 ID) — BIGSERIAL — Primary key — NOT NULL
- user_id (회원 ID) — BIGINT — Foreign key → user.id — NOT NULL
- total_amount (총 가격) — BIGINT
- status (주문상태) — VARCHAR(20)
- payment_method (결제방법) — VARCHAR(50)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
- deleted_at (삭제일시) — TIMESTAMP
payment (결제)
- id (결제 ID) — BIGSERIAL — Primary key — NOT NULL
- order_id (주문 ID) — BIGINT — Foreign key → orders.id — NOT NULL
- method (결제방식) — VARCHAR(20)
- bank_name (입금은행) — VARCHAR(100)
- account_number (입금계좌) — VARCHAR(100)
- confirmed (관리자 수동 확인여부) — BOOLEAN
- confirmed_at (확인일시) — TIMESTAMP
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
- deleted_at (삭제일시) — TIMESTAMP
product (상품)
- id (상품 ID) — BIGSERIAL — Primary key — NOT NULL
- user_id (회원 ID) — BIGINT — Foreign key → user.id — NOT NULL
- name (상품명) — VARCHAR(100)
- description (상품소개) — TEXT
- price (상품가격) — BIGINT
- stock (재고) — BIGINT
- status (상품상태) — VARCHAR(20)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
- deleted_at (삭제일시) — TIMESTAMP
product_image (상품 이미지)
- id (상품 이미지 ID) — BIGSERIAL — Primary key — NOT NULL
- product_id (상품 ID) — BIGINT — Foreign key → product.id — NOT NULL
- image_url (이미지 경로) — VARCHAR(255)
- is_thumbnail (대표이미지 여부) — BOOLEAN
- created_at (생성일시) — TIMESTAMP
seller_info (판매자 정보)
- id (판매자 정보 ID) — BIGSERIAL — Primary key — NOT NULL
- user_id (회원 ID) — BIGINT — Foreign key → user.id — NOT NULL
- business_name (상호명) — VARCHAR(255)
- business_number (사업자등록번호) — VARCHAR(50)
- bank_name (은행명) — VARCHAR(100)
- bank_account (계좌번호) — VARCHAR(100)
- store_description (소개) — TEXT
- status (판매자 상태) — VARCHAR(20)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
- deleted_at (삭제일시) — TIMESTAMP
user (회원)
- id (회원 ID) — BIGSERIAL — Primary key — NOT NULL
- email (이메일) — VARCHAR(50)
- password (비밀번호) — VARCHAR(100)
- phone (연락처) — VARCHAR(50)
- role (역할) — VARCHAR(20)
- provider (가입 경로) — VARCHAR(20)
- provider_id (플랫폼의 유저 ID) — VARCHAR(255)
- profile_image (프로필 이미지) — TEXT
- address (주소) — VARCHAR(255)
- status (회원 상태) — VARCHAR(20)
- created_at (생성일시) — TIMESTAMP
- updated_at (수정일시) — TIMESTAMP
- deleted_at (삭제일시) — TIMESTAMP