danaga

Tables (18)

Board

  • id — number — Primary key — NOT NULL
  • 제목 (title) — varchar2
  • 내용 (content) — varchar2
  • 조회수 (read_count) — number
  • 좋아요 (is_like) — number
  • 싫어요 (dislike) — number
  • 관리자 (is_admin) — number
  • 게시일 (create_time) — date
  • 수정일 (update_time) — date
  • 이미지 (img1) — varchar2
  • bg_id (id2) — number — Foreign key → BoardGroup.id — NOT NULL
  • m_id (id3) — number — Foreign key → Member.id — NOT NULL

BoardGroup

  • id — number — Primary key — NOT NULL
  • 분류명 (name) — varchar2

Cart

  • id — number — Primary key — NOT NULL
  • 수량 (qty) — number
  • 생성일 (create_time) — date
  • 수정일 (update_time) — date
  • m_id (id2) — number — Foreign key → Member.id — NOT NULL
  • os_id (id3) — number — Foreign key → OptionSet.id — NOT NULL

Category

  • id — number — Primary key — NOT NULL
  • 카테고리명 (name) — varchar2
  • 상위카테고리 (parent) — number

CategorySet

  • id — number — Primary key — NOT NULL
  • c_id (id2) — number — Foreign key → Category.id — NOT NULL
  • p_id (id3) — number — Foreign key → Product.id — NOT NULL

Comment

  • id — number — Primary key — NOT NULL
  • 내용 (content) — varchar2
  • 비밀번호 (pw) — varchar2
  • 작성자 (writer) — varchar2
  • 작성일 (create_time) — date
  • 수정일 (update_time) — date
  • b_id (id2) — number — Foreign key → Board.id — NOT NULL

Delivery

  • id — number — Primary key — NOT NULL
  • 주문자 (name) — varchar2
  • 배송지 (address) — varchar2
  • 전화번호 (phone_number) — varchar2
  • 상세주소 (detail_address) — varchar2
  • 우편번호 (post_code) — varchar2
  • o_id (id2) — number — Foreign key → Orders.id — NOT NULL

Interest

  • id — number — Primary key — NOT NULL
  • 생성일 (create_time) — date
  • 수정일 (update_time) — date
  • os_id (id2) — number — Foreign key → OptionSet.id — NOT NULL
  • m_id (id3) — number — Foreign key → Member.id — NOT NULL

Like_Config

  • id — number — Primary key — NOT NULL
  • 좋아요 (is_like) — number
  • 싫어요 (dis_like) — number
  • m_id (id2) — number — Foreign key → Member.id — NOT NULL
  • b_id (id3) — number — Foreign key → Board.id — NOT NULL

Member

  • id — number — Primary key — NOT NULL
  • 유저아이디 (username) — varchar2
  • 직책 (role) — varchar2
  • 우편번호 (post_code) — varchar2
  • 전화번호 (phone_no) — varchar2
  • 비밀번호 (password) — varchar2
  • 닉네임 (nickname) — varchar2
  • 이름 (name) — varchar2
  • 등급 (grade) — varchar2
  • 이메일 (email) — varchar2
  • 상세주소 (detail_address) — varchar2
  • 주소 (address) — varchar2
  • 등급점수 (grade_point) — number
  • 가입일 (join_date) — date
  • 생일 (birthday) — date

OptionSet

  • id — number — Primary key — NOT NULL
  • 등록일 (create_time) — date
  • 수정일 (update_time) — date
  • 조회수 (view_count) — number
  • 가격 (total_price) — number
  • 판매수 (order_count) — number
  • 재고 (stock) — number
  • product_id — number — Foreign key → Product.id — NOT NULL

Options

  • id — number — Primary key — NOT NULL
  • 옵션명 (name) — varchar2
  • 옵션값 (value) — varchar2
  • 추가금 (extra_price) — number
  • os_id (id2) — number — Foreign key → OptionSet.id — NOT NULL

OrderItem

  • id — number — Primary key — NOT NULL
  • 수량 (qty) — number
  • os_id (id2) — number — Foreign key → OptionSet.id — NOT NULL
  • o_id (id3) — number — Foreign key → Orders.id — NOT NULL

Orders

  • id — number — Primary key — NOT NULL
  • 주문상태 (status) — varchar2
  • 상세 (description) — varchar2
  • 주문일 (create_date) — date
  • 결제금 (price) — number
  • m_id (id2) — number — Foreign key → Member.id — NOT NULL

Product

  • id — number — Primary key — NOT NULL
  • 제품명 (name) — varchar2
  • 제조사 (brand) — varchar2
  • 기본가격 (price) — number
  • 등록일 (create_time) — date
  • 수정일 (update_time) — date
  • 제품이미지 (img) — varchar2
  • 제품썸네일 (prev_img) — varchar2
  • 제품상세이미지 (desc_img) — varchar2

RecentView (Recent_View)

  • id — number — Primary key — NOT NULL
  • 생성일 (create_time) — date
  • 수정일 (update_time) — date
  • os_id (id2) — number — Foreign key → OptionSet.id — NOT NULL
  • m_id (id3) — number — Foreign key → Member.id — NOT NULL

Refund

  • id — number — Primary key — NOT NULL
  • 계좌번호 (ac_no) — varchar2
  • 계좌주명 (account_name) — varchar2
  • 은행 (bank_name) — varchar2
  • 상세 (description) — varchar2
  • o_id (id2) — number — Foreign key → Orders.id — NOT NULL

Statistics

  • id — number — Primary key — NOT NULL
  • 신규가입 (daily_new_member) — number
  • 판매수익 (daily_sales_revenue) — number
  • 판매량 (daily_sales_qty) — number
  • 문의글 (daily_board_inquriy)