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')