1

Tables (14)

accounts (계좌)

  • account_number (계좌번호) — varchar2(100) — Primary key — NOT NULL
  • member_ID (사용자번호) — int — Foreign key → members.member_ID — NOT NULL
  • account_bank (은행) — varchar2(100)
  • account_registor_date (등록일) — timestamp

arts (작품)

  • art_ID (작품번호) — int — Primary key — NOT NULL
  • member_ID (판매자) — int — Foreign key → members.member_ID — NOT NULL
  • mini_category_ID (미니카테고리번호) — int — Foreign key → mini_categories.mini_category_ID — NOT NULL
  • art_title (제목) — varchar2(100)
  • art_price (가격) — int
  • art_description (설명) — varchar2(100000)
  • art_status (판매상태) — varchar2(100)
  • art_like (좋아요수) — int
  • art_view (조회수) — int
  • art_post_date (등록일) — timestamp
  • art_size (크기) — varchar2(500)
  • art_thumbnail_image (썸네일이미지, 이미지1) — varchar2(100)
  • art_hovering_image (호버링이미지) — varchar2(100)
  • art_image2 (이미지2) — varchar2(100)
  • art_image3 (이미지3) — varchar2(100)
  • art_image4 (이미지4) — varchar2(100)
  • art_image5 (이미지5) — varchar2(100)

auth_code (인증)

  • auth_expired (만료시간) — date
  • auth_code (인증코드) — varchar2(200)
  • auth_method (요청 방법) — varchar2(200)

blocks (차단)

  • member_ID (사용자번호) — int — Foreign key → members.member_ID — NOT NULL
  • block_id (차단된 회원) — int

carts (장바구니)

  • art_ID (작품번호) — int — Foreign key → arts.art_ID — NOT NULL
  • member_ID (사용자번호) — int — Foreign key → members.member_ID — NOT NULL

categories (카테고리)

  • category_ID (카테고리번호) — int — Primary key — NOT NULL
  • catgory_type (카테고리종류) — varchar2(100)

chat_rooms (채팅방)

  • room_ID (채팅방번호) — int — Primary key — NOT NULL
  • member_ID (구매자번호) — int — Foreign key → members.member_ID — NOT NULL
  • art_ID (작품번호) — int — Foreign key → arts.art_ID — NOT NULL

chats (채팅)

  • chat_ID (채팅번호) — int — Primary key — NOT NULL
  • room_ID (채팅방번호) — int — Foreign key → chat_rooms.room_ID — NOT NULL
  • member_ID (회원번호) — int — Foreign key → chat_rooms.member_ID — NOT NULL
  • chat_message (메세지) — varchar2(5000)
  • chat_time (채팅시간) — timestamp
  • chat_image1 (사진1) — varchar2(100)
  • chat_image2 (사진2) — varchar2(100)
  • chat_image3 (사진3) — varchar2(100)
  • isRead (읽음여부) — boolean

exhibitions (전시회)

  • exhbition_ID (전시회번호) — int — Primary key — NOT NULL
  • exhibition_title (제목) — varchar2(100)
  • exhibition_univ (대학교) — varchar2(100)
  • exhibition_major (학과) — varchar2(100)
  • exhibition_location (장소) — varchar2(100)
  • exhibition_link (전시회 링크) — varchar2(5000)
  • exhibition_poster (포스터) — varchar2(5000)
  • exhibition_start_date (시작일) — date
  • exhibition_end_date (종료일) — date

likes (찜)

  • member_ID (사용자번호) — int — Foreign key → members.member_ID — NOT NULL
  • art_ID (작품번호) — int — Foreign key → arts.art_ID — NOT NULL

members (회원)

  • member_ID (사용자번호) — int — Primary key — NOT NULL
  • member_login_ID (로그인ID) — varchar2(100)
  • member_password (비밀번호) — varchar2(100)
  • member_name (이름) — varchar2(100)
  • member_birth (생년월일) — date
  • member_phone (전화번호) — varchar2(100)
  • member_address (주소) — varchar2(100)
  • member_address_detail (상세주소) — varchar2(100)
  • member_email (이메일) — varchar2(100)
  • member_is_artist (판매자여부) — boolean

mini_categories (미니카테고리)

  • mini_category_ID (미니카테고리번호) — int — Primary key — NOT NULL
  • category_ID (카테고리번호) — int — Foreign key → categories.category_ID — NOT NULL
  • mini_catgory_type (카테고리종류) — varchar2(100)

order_items (주문물품)

  • art_ID (작품번호) — int — Foreign key → arts.art_ID — NOT NULL
  • order_ID (주문번호) — int — Foreign key → orders.order_ID — NOT NULL

orders (주문)

  • order_ID (주문번호) — int — Primary key — NOT NULL
  • member_ID (구매자) — int — Foreign key → members.member_ID — NOT NULL
  • order_date (결제일) — timestamp
  • order_request (요청사항) — varchar2(5000)
  • oder_paymentMethod (결제수단) — varchar2(200)