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)