AppleFram

Tables (29)

ADDRESS_TBL

  • ADDRESS_NO — NUMBER — Primary key — NOT NULL — PRIMARY KEY
  • MEMBER_NO — NUMBER — Foreign key → MEMBER_TBL.MEMBER_NO — NOT NULL
  • ZIPCODE — CHAR(5) — NOT NULL
  • ADDRESS — VARCHAR2(200) — NOT NULL
  • ADDRESS_DETAIL — VARCHAT2(100)
  • ADDRESS_NAME — VARCHAR2(30) — NOT NULL
  • ADDRESS_PHONE — CHAR(13) — NOT NULL
  • ADDRESS_REQUEST — VARCHAR2(200) — 없앨거임
  • ADDRESS_DEFAULT — NUMBER — 0:일반 배송지1: 기본배송지

AIRPODS_QUALITY_HISTORY_TBL

  • AIRPODS_QUALITY_HISTORY_NO — VARCHAR(255) — Primary key — NOT NULL
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL — MEMBER_NICKNAME
  • SOUND_QUALITY — VARCHAR(255) — NOT NULL
  • CONNECTION_STABILITY — VARCHAR(255) — NOT NULL
  • BATTERY_EFFICIENCY — VARCHAR(255) — NOT NULL
  • EXTERIOR — VARCHAR(255) — NOT NULL
  • CHARGING — VARCHAR(255) — NOT NULL
  • TOUCH_SENSOR — VARCHAR(255) — NOT NULL

AIRPODS_TBL

  • PRODUCT_LINE — VARCHAR2(100) — NOT NULL — 맥스, 프로,일반
  • AIRPODS_GEN — VARCHAR2(100) — NOT NULL — n세대
  • AIRPODS_COLOR — VARCHAR2(100) — NOT NULL
  • AIRPODS_IMAGE — VARCHAR2(500) — NOT NULL — `AIRPODS_CHARGE` VARCHAR2(100) NOT NULL COMMENT '유선충

BID_TBL

  • BID_NO — NUMBER — Primary key — NOT NULL — 로그인 된 정보에서 가져오기
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL — 구매자가 사려는 금액' `MEMBER_NO` NUMBER NOT NULL COMMENT 'Primary Key, SEQUENCE
  • BID_PRICE — NUMBER — NOT NULL — PRODUCT_TBL이랑 JOIN해서 RPODUCT_SUMMARY 가져와야 함. 상품이 뭔지 보여주는 용도

BOARD_FILE_TBL

  • FILE_NO — NUMBER — Primary key — NOT NULL — PK, SEQ
  • BOARD_NO — NUMBER — Foreign key → BOARD_TBL.BOARD_NO — NOT NULL
  • FILE_NAME — VARCHAR2(300) — NOT NULL
  • FILE_PATH — VARCHAR2(300) — NOT NULL — EX) "욕설을 사용했어요"

BOARD_TBL

  • BOARD_NO — NUMBER — Primary key — NOT NULL — Primary Key, SEQUENCE
  • BOARD_TITLE — VARCHAR2(100) — NOT NULL
  • BOARD_CONTENT — VARCHAR2(4000) — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER_TBL.MEMBER_NO — NOT NULL — MEMBER_NO
  • READ_COUNT — NUMBER — NOT NULL
  • BOARD_TYPE — NUMBER — NOT NULL — 1: 공지사항 2: 자유게시판 3 : 뽐내기 4: 매거진
  • PRODUCT_CATEGORY — VARCHAR2(50) — IPHONE, MACBOOK, IPAD, APPLEWATCH, AIRPODS
  • BOARD_HIDE — CHAR(1) — NOT NULL — 0 : 보여주기, 1 : 숨기기
  • BOARD_DATE — DATE — NOT NULL
  • BOARD_THUMBNAIL — VARCHAR2(100)

COLOR_TBL

  • color — VARCHAR2(100) — NOT NULL — EX) IPHONE_TBL, MACBOOK_TBL, IPAD_TBL, WATCH_TBL, AIRPODS_TBL
  • colorImage — VARCHAR2(300) — NOT NULL — 액정

COMMENT

  • COMMENT_NO — NUMBER — NOT NULL — BOARD_NO` NUMBER NOT NUL
  • COMMENT — 'MEMBER_NO' — MEMBER_NO
  • _WRITER — NUMBER — COMMENT '널=댓글, 널x=대댓글
  • _CONTENT — VARCHAR2(500) — NOT NULL — 0 : 보여주기, 1 : 숨기기
  • COMMENT — 'Primary — Primary Key, SEQUENCE
  • _HIDE — CHAR(1) — NOT NULL — COMMENT 'db에 저장되는 이름'_DATE` DATE NOT NUL

IPAD_QUALITY_HISTORY_TBL

  • IPAD_QUALITY_HISTORY_NO — NUMBER — Primary key — NOT NULL
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL — PK, SEQ
  • DISPLAY_SCREEN — VARCHAR(255) — NOT NULL
  • BACK_PANEL_SIDE — VARCHAR(255) — NOT NULL
  • BURN_IN — VARCHAR(255) — NOT NULL
  • DISPLAY — VARCHAR(255) — NOT NULL
  • PORTS — VARCHAR(255) — NOT NULL
  • BATTERY_EFFICIENCY — VARCHAR(255) — NOT NULL
  • WIRELESS_CONNECTIVITY — VARCHAR(255) — NOT NULL
  • CAMERA — VARCHAR(255) — NOT NULL
  • MICROPHONE — VARCHAR(255) — NOT NULL
  • SPEAKERS_AUDIO_JACK — VARCHAR(255) — NOT NULL
  • BIOMETRIC_AUTHENTICATION — VARCHAR(255) — NOT NULL
  • POWER — VARCHAR(255) — NOT NULL
  • VOICE_RECORDING — VARCHAR(255) — NOT NULL
  • OPERATION — VARCHAR(255) — NOT NULL

IPAD_TBL

  • PRODUCT_LINE — VARCHAR2(100) — NOT NULL — iPad Pro 12.9, iPad Pro 11, iPad Air, iPad Mini, iPad
  • IPAD_GEN — VARCHAR2(100) — NOT NULL — n세대(칩) /////
  • IPAD_COLOR — VARCHAR2(100) — NOT NULL
  • IPAD_IMAGE — VARCHAR2(500) — NOT NULL — `IPAD_STORAGE` VARCHAR2(100) NOT NULL, `IPAD_CONNECTIVITY` VARCHAR2(100) NOT NULL COMMENT 'WI-F

IPHONE_QUALITY_HISTORY_TBL

  • IPHONE_QUALITY_HISTORY_NO — NUMBER — Primary key — NOT NULL
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL — PK, SEQ
  • DISPLAY_SCREEN — VARCHAR2(100) — NOT NULL
  • BACK_PANEL_SIDE — VARCHAR(255) — NOT NULL
  • BURN_IN — VARCHAR(255) — NOT NULL
  • DISPLAY — VARCHAR(255) — NOT NULL
  • POWER — VARCHAR(255) — NOT NULL
  • CAMERA — VARCHAR(255) — NOT NULL
  • WIFI — VARCHAR(255) — NOT NULL
  • BIOMETRIC_AUTHENTICATION — VARCHAR(255) — NOT NULL
  • COMPASS — VARCHAR(255) — NOT NULL
  • VOICE_RECORDING — VARCHAR(255) — NOT NULL

IPHONE_TBL

  • PRODUCT_LINE — VARCHAR2(100) — NOT NULL — iPhone
  • IPHONE_GEN — VARCHAR2(100) — NOT NULL — iPhone 15 Series, iPhone 14 Series
  • IPHONE_MODEL — VARCHAR2(100) — NOT NULL — iPhone 15, iPhone Plus, iPhone Pro, iPhone Pro Max, ... /////
  • IPHONE_COLOR — VARCHAR2(100) — NOT NULL
  • IPHONE_IMAGE — VARCHAR2(500) — NOT NULL — `IPHONE_STORAGE` VARCHAR2(100) NOT NUL

LIKE_TBL

  • LIKE_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER_TBL.MEMBER_NO — NOT NULL
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL

MACBOOK_QUALITY_HISTORY_TBL

  • MACBOOK_QUALITY_HISTORY_NO — NUMBER — Primary key — NOT NULL
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL — PK, SEQ
  • DISPLAY_SCREEN — VARCHAR(255) — NOT NULL
  • BACK_PANEL_SIDE — VARCHAR(255) — NOT NULL
  • BURN_IN — VARCHAR(255) — NOT NULL
  • DISPLAY — VARCHAR(255) — NOT NULL
  • KEYBOARD — VARCHAR(255) — NOT NULL
  • PORTS — VARCHAR(255) — NOT NULL
  • BATTERY_EFFICIENCY — VARCHAR(255) — NOT NULL
  • WIRELESS_CONNECTIVITY — VARCHAR(255) — NOT NULL
  • CAMERA — VARCHAR(255) — NOT NULL
  • MICROPHONE — VARCHAR(255) — NOT NULL
  • SPEAKERS_AUDIO_JACK — VARCHAR(255) — NOT NULL
  • BIOMETRIC_AUTHENTICATION — VARCHAR(255) — NOT NULL
  • POWER — VARCHAR(255) — NOT NULL
  • VOICE_RECORDING — VARCHAR(255) — NOT NULL
  • TRACKPAD — VARCHAR(255) — NOT NULL
  • OPERATION — VARCHAR(255) — NOT NULL

MACBOOK_TBL

  • PRODUCT_LINE — VARCHAR2(100) — NOT NULL — MacBook Pro, MacBook Air
  • MACBOOK_GEN — VARCHAR2(100) — NOT NULL — M3, M2, M1, 인텔 10세대, ...
  • MACBOOK_MODEL — VARCHAR2(100) — NOT NULL — 13인치, 14인치, 15인치, 16인치 /////
  • MACBOOK_MODEL2 — VARCHAR2(100) — M3 M3 Pro M3 Max, Thunderbolt3 개수 등
  • MACBOOK_COLOR — VARCHAR2(100) — NOT NULL
  • MACBOOK_IMAGE — VARCHAR2(500) — NOT NULL
  • MACBOOK_STORAGE — VARCHAR2(100) — NOT NULL — 128GB,256GB,512GB
  • MACBOOK_MEMORY — VARCHAR2(100) — NOT NULL
  • MACBOOK_CHIP — VARCHAR2(100) — M3(n코어CPU+n코어GPU), M3 Pro(n코어CPU+n코어GPU),M3 Pro(nn코어CPU+nn코어GPU), M3 Max...
  • MACBOOK_CPU — VARCHAR2(100) — Intel 맥에서
  • MACBOOK_GPU — VARCHAR2(100) — Intel 맥에서

MEMBER_TBL

  • MEMBER_NO — NUMBER — Primary key — NOT NULL
  • MEMBER_NAME — VARCHAR2(30) — NOT NULL
  • MEMBER_NICKNAME — VARCHAR2(30) — NOT NULL — UNIQUE
  • MEMBER_ID — VARCHAR2(30) — NOT NULL — UNIQUE
  • MEMBER_PW — CHAR(60) — NOT NULL
  • MEMBER_EMAIL — VARCHAR2(100) — NOT NULL
  • MEMBER_PHONE — CHAR(13) — NOT NULL — 010-1111-1111
  • MEMBER_GRADE — NUMBER — NOT NULL — 1:사용자 2:관리자 // 3: 블랙(게시글 및 후기, 댓글 작성 금지-1일)
  • MEMBER_ACCOUNTNUMBER — VARCHAR2(50) — 은행명+입금계좌번호
  • ENROLL_DATE — DATE — NOT NULL — 2024-03-25
  • SELLER_SCORE — NUMBER — NOT NULL — 0~100 사이. 시작 37점.
  • SELLER_GRADE — NUMBER — NOT NULL — (1~3) 레벨에따른 수수료 부가
  • MEMBER_WITHDRAW — CHAR((1) — NOT NULL — 0 : 정상회원 /1: 탈퇴회원 →1일 경우 해당 계정으로 로그인 금지
  • MEMBER_BLACK_TIME — TIMESTAMP

NOTE_TBL

  • NOTE_NO — NUMBER — Primary key — NOT NULL — `SENDER_MEMBER_NO` NUMBER NOT NULL, `RECEIVER_MEMBER_NO` NUMBER NOT NULL, `PRODUCT_NO` NUMBER NULL COMMENT ' `NOTE_TITL…
  • NOTE_CONTENT — VARCHAR2(2000) — NOT NULL
  • SEND_DATE — DATE — NOT NULL
  • RECEIVE_DATE — DATE — NOT NULL
  • RECEIVER_READ — CHAR(1) — NOT NULL — `RECEIVER_DELETE` CHAR(1) NOT NULL COMMENT 'join using color', `SENDER_DELETE` CHAR(1) NOT NULL COMMENT '이미지 파일명 입력

PRODUCT_FILE_TBL

  • FILE_NO — NUMBER — Primary key — NOT NULL — REPORT_TBL과 조인
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL
  • FILE_NAME — VARCHAR2(100) — NOT NULL
  • FILE_PATH — VARCHAR2(100) — NOT NULL

PRODUCT_TBL

  • PRODUCT_NO — NUMBER — Primary key — NOT NULL — PK, SEQ
  • MEMBER_NO — NUMBER — Foreign key → MEMBER_TBL.MEMBER_NO — NOT NULL — FK
  • PRODUCT_QUALITY — CHAR(1) — NOT NULL — 'A', 'B
  • D, — `PRODUCT_TITLE` — NOT NULL — 판매자가 직접 입력하는 상품 판매글 제목
  • PRODUCT_EXPLAIN — VARCHAR2(4000) — 판매자가 직접 입력하는 상품설명
  • PRODUCT_PRICE — NUMBER — NOT NULL — 숫자타입으로 저장. 화면에 출력할 때에는 천 단위로 콤마 찍을 것
  • PRODUCT_DATE — DATE — NOT NULL — 등록시 sysdate
  • PRODUCT_HIDE — CHAR(1) — NOT NULL — 0 : 보여주기, 1: 숨기기
  • PRODUCT_LINE — VARCHAR2(100) — NOT NULL
  • PRODUCT_GEN — VARCHAR2(100)
  • PRODUCT_MODEL — VARCHAR2(100) — 아이폰,맥북,아이패드,애플워치 // 에어팟X
  • PRODUCT_MODEL2 — VARCHAR2(100) — 맥북
  • PRODUCT_COLOR — VARCHAR2(100)
  • PRODUCT_STORAGE — VARCHAR2(100) — 아이폰, 맥북, 아이패드
  • PRODUCT_MEMORY — VARCHAR2(100) — 맥북, 아이패드
  • PRODUCT_CHIP — VARCHAR2(100) — 맥북 M3세대만
  • PRODUCT_CPU — VARHCAR2(100) — 맥북 - Intel 맥에서
  • PRODUCT_GPU — VARCHAR2(100) — 맥북 - Intel 맥에서
  • PRODUCT_SIZE — VARCHAR2(100) — 애플워치
  • PRODUCT_CONNECTIVITY — VARCHAR2(100) — 아이패드, 애플워치
  • PRODUCT_CHARGE — VARCHAR2(100) — 에어팟
  • PRODUCT_THUMBNAIL — VARCHAR2(100)
  • PRODUCT_SUMMARY — VARHCAHR2(300) — NOT NULL — EX) iPhone 15 Pro 화이트 256GB A급 → 쪽지테이블 등에, 상품판매글 리스트 등에 간략하게 띄울 용도
  • TABLE_NAME — VARCHAR2(50) — NOT NULL — 테이블명은 대문자로 함 그냥...!!! IPHONE_TBL, MACBOOK_TBL, IPAD_TBL, WATCH_TBL, AIRPODS_TBL

QUALITY_TBL

  • TABLE_NAME — VARCHAR2(50) — NOT NULL — 정상/경미한 잔기스/심한 기스, 파손, 전면 뜸/심각한 파손
  • PART — VARCHAR2(50) — NOT NULL — liquidCrystal1/liquidCrystal2
  • PRODUCT_STATUS — VARCHAR2(300) — NOT NULL — DISPLAY_SCREEN' `PRODUCT_STATUS_IMAGE` VARCHAR2(300) NULL COMMENT 'PK, SEQ
  • PART2 — VARCHAR2(100) — NOT NULL — PK, SEQ

REFUND_TBL

  • REFUND_NO — NUMBER — Primary key — NOT NULL — 신청일
  • TRADE_NO — NUMBER — Foreign key → TRADE_TBL.TRADE_NO — NOT NULL
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL — 신청,진행중(0), 반려(->구매확정, 1) , 승인(2)' `REFUND_DATE` DATE NOT NULL COMMENT 'P
  • SEQ, — `REFUND_REASON` — NOT NULL — 1대1문의는 판매번호 안보낼경우 생각해서 NULL

REPORT_SELECT_REFERENCE_TBL

  • REPROT_SELECT_NO — NUMBER — Primary key — NOT NULL
  • REPROT_SELECT_CONTENT — VARCHAR2(100) — NOT NULL — REPORT_SELECT_REFERENCE_TBL과 조인

REPORT_SELECT_TBL

  • REPORT_NO — NUMBER — Foreign key → REPORT_TBL.REPORT_NO — NOT NULL — PK, SEQ
  • REPROT_SELECT_NO — NUMBER — Foreign key → REPORT_SELECT_REFERENCE_TBL.REPROT_SELECT_NO — NOT NULL — FK ,삭제시 같이삭제

REPORT_TBL

  • REPORT_NO — NUMBER — Primary key — NOT NULL — Primary Key, SEQUENCE
  • REPORT_TYPE — NUMBER — NOT NULL — 1(상품판매글), 2(뽐내기게시판), 3(뽐내기댓글)
  • REPORT_TARGET — NUMBER — NOT NULL — 각 유형에 맞게 PK넘겨주기. (상품판매글, 상품후기, 자유,뽐내기, 댓글)번호
  • REPORT_CONTENT — VARCHAR2(1000) — 신고유형 기타일시 활성화
  • REPORT_DATE — DATE — NOT NULL
  • REPORTING_MEMBER — NUMBER — Foreign key → MEMBER_TBL.MEMBER_NO — NOT NULL — MEMBER_NO
  • REPORTED_MEMBER — NUMBER — Foreign key → MEMBER_TBL.MEMBER_NO — NOT NULL — MEMBER_NO
  • REPORT_STATUS — NUMBER — NOT NULL — 진행중(0), 반려(1), 제재(2)
  • REPORT_ACTION_DATE — DATE

REVIEW_TBL

  • TRADE_NO — NUMBER — Foreign key → TRADE_TBL.TRADE_NO — NOT NULL — 신고 시 전달할 번호
  • REVIEW_SELLER — NUMBER — Foreign key → MEMBER_TBL.MEMBER_NO — NOT NULL
  • REVIEW_CONSUMER — NUMBER — Foreign key → MEMBER_TBL.MEMBER_NO — NOT NULL — 탈퇴회원입니다 띄우기
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL
  • REVIEW_SATISFACTION — NUMBER — NOT NULL — -1:불만족, 0:보통, 1:만족
  • REVIEW_DETAIL — VARCHAR2(3000) — 상세후기내용

SALE_INQUIRIDE_TBL

  • INQUIRY_NO — NUMBER — Primary key — NOT NULL
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL
  • INQUIRY_CONTENT — VARCHAR2(3000) — NOT NULL

TRADE_TBL

  • TRADE_NO — NUMBER — Primary key — NOT NULL
  • TRADE_SELLER — NUMBER — Foreign key → MEMBER_TBL.MEMBER_NO — NOT NULL — MEMBER_NO
  • TRADE_BUYER — NUMBER — Foreign key → MEMBER_TBL.MEMBER_NO — NOT NULL — MEMBER_NO
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL — PRODUCT_TBL이랑 JOIN해서 RPODUCT_SUMMARY 가져와야 함. 상품이 뭔지 보여주는 용도
  • TRADE_RESERVE_DATE — DATE — TRADE_STATE = "예약중"인 것의 예약일임
  • TRADE_DATE — DATE — NOT NULL — SYSDATE
  • TRADE_PRICE — NUMBER — NOT NULL
  • TRADE_STATE — VARCHAR2(30) — NOT NULL — 예약중(취소시 삭제), 결제완료, 발송대기, 배송중, 배송완료, 구매확정 or 환불
  • ZIPCODE — CHAR(5) — NOT NULL
  • ADDRESS — VARCHAR2(200) — NOT NULL
  • ADDRESS_DETAIL — VARCHAR2(100)
  • ADDRESS_NAME — VARCHAR2(30) — NOT NULL
  • ADDRESS_PHONE — CHAR(13) — NOT NULL
  • ADDRESS_REQUEST — VARCHAR2(200) — NOT NULL
  • INVOICE_NUMBER — VARCHAR2(30) — 구매자가 결제완료후 판매자가 판매물품 택배보내면서 등록
  • PAYMENT_NUMBER — NUMBER — 구매자가 카드결제하고 받은 번호
  • DELIVERY_DATE — DATE — 배송완료일

WATCH_QUALITY_HISTORY_TBL

  • WATCH_QUALITY_HISTORY_NO — VARCHAR(255) — Primary key — NOT NULL
  • PRODUCT_NO — NUMBER — Foreign key → PRODUCT_TBL.PRODUCT_NO — NOT NULL — PK, SEQ
  • DISPLAY_SCREEN — VARCHAR(255) — NOT NULL
  • BACK_PANEL_SIDE — VARCHAR(255) — NOT NULL
  • BURN_IN — VARCHAR(255) — NOT NULL
  • DISPLAY — VARCHAR(255) — NOT NULL
  • DIGITAL_CROWN_BUTTON — VARCHAR(255) — NOT NULL
  • BATTERY_EFFICIENCY — VARCHAR(255) — NOT NULL
  • WIRELESS_CONNECTIVITY — VARCHAR(255) — NOT NULL
  • MICROPHONE — VARCHAR(255) — NOT NULL
  • SPEAKER — VARCHAR(255) — NOT NULL
  • POWER — VARCHAR(255) — NOT NULL
  • VOICE_RECORDING — VARCHAR(255) — NOT NULL
  • OPERATION — VARCHAR(255) — NOT NULL

WATCH_TBL

  • PRODUCT_LINE — VARCHAR2(100) — NOT NULL — Apple Watch Ultra, Apple Watch Series, Apple Watch SE
  • WATCH_GEN — VARCHAR2(100) — NOT NULL — n세대
  • WATCH_MODEL — VARCHAR2(100) — NOT NULL — 알루미늄, 스테인리스 스틸
  • WATCH_COLOR — VARCHAR2(100) — NOT NULL
  • WATCH_IMAGE — VARCHAR2(500) — NOT NULL — `WATCH_SIZE` VARCHAR2(100) NOT NULL COMMENT '41m
  • ..., — `WATCH_CONNECTIVITY` — NOT NULL — GP