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