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