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)