semi-frip
Tables (11)
feed_tbl (피드)
- feed_no (피드번호) — Number — Primary key — NOT NULL — Primary key
- feed_writer (피드작성자) — varchar2(30) — Foreign key → member_tbl.member_no — NOT NULL — references member_tbl(member_id) on delete casade
- frip_no (프립번호) — Number — Foreign key → frip_tbl.frip_no — NOT NULL — references frip_tbl on delete set null
- feed_content (피드내용) — varchar2(1000) — NOT NULL
- file_name (댓글사진이름) — varchar2(100)
- file_path (댓글사진저장이름) — varchar2(100)
- fd_no (피드넘버레퍼런스) — number — references feed_tbl(feed_no)
- write_date (작성일자) — varchar2(30) — NOT NULL
frip_category (프립카테고리)
- category_no (Key) — Number — Primary key — NOT NULL — primary key
- frip_no (프립번호) — Number — Foreign key → frip_tbl.frip_no — NOT NULL — references frip_tbl on delete cascade
- category_name (카테고리명) — varchar2(30) — NOT NULL
frip_file (프립파일)
- frip_file_no (Key) — Number — Primary key — NOT NULL — primary key
- frip_no (프립번호) — Number — Foreign key → frip_tbl.frip_no — NOT NULL — references frip_tbl on delete cascade
- file_path (파일저장이름) — varchar2(100)
frip_inquiry (프립문의)
- frip_inquiry_no (Key) — Number — Primary key — NOT NULL — primary key
- frip_no (프립번호) — Number — Foreign key → frip_tbl.frip_no — NOT NULL — references frip_tbl on delete set null
- inquiry_writer (문의작성자) — varchar2(30) — Foreign key → member_tbl.member_no — NOT NULL — references member_tbl(member_id) on delete set null
- inquiry_content (문의내용) — varchar2(300) — NOT NULL
- fi_no (대댓글용번호) — Number — references frip_inquiry
- write_date (작성날짜) — varchar2(30) — NOT NULL
frip_joinable_date (참여가능날짜)
- joinable_date_no (Key) — Number — Primary key — NOT NULL — primary key
- frip_no (프립번호) — Number — Foreign key → frip_tbl.frip_no — NOT NULL — references frip_tbl
- joinable_date (참여가능날짜) — varchar2(30) — NOT NULL
- joinable_time (참여가능시간) — varchar2(30) — NOT NULL
- unique(frip_no,joinable_date) (프립날짜중복불가)
- max_count (참여가능인원수) — Number — NOT NULL
frip_tbl (프립)
- frip_no (프립번호) — Number — Primary key — NOT NULL — primary key
- frip_writer (플립작성자) — varchar2(300) — Foreign key → member_tbl.member_no — NOT NULL — references member_tbl(member_id)
- frip_auth (플립허가) — Boolean — NOT NULL
- frip_title (제목) — varchar2(30) — NOT NULL
- frip_content (내용) — varchar2(4000) — NOT NULL
- frip_addr (주소) — varchar2(100) — NOT NULL
- frip_detail_addr (상세주소) — varchar2(100)
- frip_level (난이도) — varchar2(10) — CHECK (FRIP_LEVEL IN('EASY','MEDIUM','HARD'))
- frip_price (가격) — Number — NOT NULL
- frip_income (판매수익) — Number — NOT NULL
- frip_status (프립상태) — char(1) — NOT NULL — CHECK (FRIP_STATUS IN ('0','1'))
- write_date (작성일자) — varchar2(30) — NOT NULL
join_frip (참여하기)
- join_frip_no (Key) — Number — Primary key — NOT NULL — primary key
- member_no (유저번호) — NUMBER — Foreign key → member_tbl.member_no — NOT NULL — REFERENCES MEMBER_TBL on delete set null
- joinable_date_no (Key2) — Number — Foreign key → frip_joinable_date.joinable_date_no — NOT NULL — references frip_joinable_date
- frip_no (프립번호) — NUMBER — Foreign key → frip_tbl.frip_no — NOT NULL — REFERENCES FRIP_TBL on delete set null
- payment_no (결제정보) — Number — Foreign key → payment_tbl.payment_no — NOT NULL — references payment_tbl on delete set null
- join_count (참여인원) — Number — NOT NULL
- Field — NOT NULL
member_tbl (유저)
- member_no (유저번호) — Number — Primary key — NOT NULL — Primary key
- member_id (아이디) — varchar2(30) — NOT NULL — unique, not null
- member_pw (비밀번호) — varchar2(30) — NOT NULL
- member_name (이름) — varchar2(30) — NOT NULL
- member_addr (주소) — varchar2(50)
- member_phone (전화번호) — char(13)
- member_level (등급) — Number — NOT NULL — 1:관리자/2:호스트/3:일반회원/4:탈퇴
- member_profile (프로필) — varchar2(300) — .jpg, ,png
- member_intro (소개) — varchar2(300)
- enroll_date (가입일) — varchar2(30) — NOT NULL
- member_addr_detail (상세주소) — varchar2(300)
- member_old_profile (예전프로필사진) — varchar2(300)
notice_tbl (공지사항)
- notice_no (공지사항 번호) — NUMBER — Primary key — NOT NULL — primary key
- notice_write (유저아이디(관리자)) — VARCHAR2(30 — Foreign key → member_tbl.member_no — NOT NULL — references member_tbl(member_id)
- notice_title (제목) — VARCHAR2(30) — NOT NULL — not null
- notice_content (내용) — VARCHAR2(1000) — NOT NULL — not null
- notice_category (공지사항종류) — VARCHAR2(100) — NOT NULL — check in('이벤트','공지','발표') (종류에 따라 분류))
- enroll_date (작성날) — varchar2(30) — NOT NULL — not null
- notice_file (공지사항 파일 이름) — varchar(100)
payment_tbl (결제영수증)
- payment_no (Key) — Number — Primary key — NOT NULL — primary key
- member_no (유저번호) — Number — Foreign key → member_tbl.member_no — NOT NULL — references member_tbl on delete set null
- frip_no (프립번호) — Number — Foreign key → frip_tbl.frip_no — NOT NULL — references frip_tbl on delete set null
- payment_type (결제수단) — varchar2(30) — NOT NULL
- total_price (전체금액) — Number — NOT NULL
- final_price (최종금액) — Number — NOT NULL
- payment_date (결제날짜) — VARCHAR2(30) — NOT NULL
rating_tbl (별점)
- rating_no (Key) — Number — Primary key — NOT NULL — primary key
- feed_no (피드번호) — Number — Foreign key → feed_tbl.feed_no — NOT NULL — references feed_tbl on delete cascade
- rating (별점) — Number — NOT NULL — check in ('0','1','2','3','4','5')