my project DB

Tables (5)

project_board (게시판)

  • bd_no (글번호) — number — Primary key — NOT NULL
  • user_no (유저 번호) — number — Foreign key → project_member.user_no — NOT NULL
  • user_id (아이디) — varchar2(10) — Foreign key → project_member.user_id
  • user_auth (권한) — varchar2(1) — Foreign key → project_member.user_auth
  • bd_title (글제목) — varchar2(100)
  • bd_content (글내용) — varchar2(4000)
  • bd_cat (카테고리) — varchar2(20)
  • bd_regdate (등록일) — date
  • bd_readcnt (조회수) — number

project_buy (구입항목)

  • se_no (글번호) — number — Foreign key → project_selling.se_no — NOT NULL
  • user_no (유저 번호) — number — Foreign key → project_selling.user_no — NOT NULL
  • user_no (유저 번호2) — number — Foreign key → project_member.user_no — NOT NULL
  • user_id (아이디) — varchar2(10) — Foreign key → project_member.user_id
  • user_auth (권한) — varchar2(1) — Foreign key → project_member.user_auth

project_member (회원정보)

  • user_no (유저 번호) — number — Primary key — NOT NULL
  • user_id (아이디) — varchar2(10) — Primary key
  • user_auth (권한) — varchar2(1) — Primary key
  • user_pwd (비밀번호) — varchar(30)
  • user_name (이름) — varchar2(20)
  • user_sex (성별) — varchar2(4)
  • user_birth (생년월일) — date
  • user_email (이메일) — varchar2(30)
  • user_address (주소) — varchar2(100)
  • user_tel (전화번호) — varchar2(20)

project_selling (판매)

  • se_no (글번호) — number — Primary key — NOT NULL
  • user_no (유저 번호) — number — Foreign key → project_member.user_no — NOT NULL
  • user_id (아이디) — varchar2(10) — Foreign key → project_member.user_id
  • se_title (상품명) — varchar2(100)
  • se_content (상품설명) — varchar2(2000)
  • se_cat (카테고리) — varchar2(20)
  • se_state (상품상태) — varchar2(10)
  • se_price (상품가격) — number
  • se_regdate (등록일) — date
  • filename (파일명) — varchar2(150)
  • filepath (파일경로) — varchar2(300)

project_selling_comment (판매상품 댓글)

  • co_no (댓글번호) — number — Primary key — NOT NULL
  • user_no (유저 번호) — number — Foreign key → project_member.user_no — NOT NULL
  • user_id (아이디) — varchar2(10) — Foreign key → project_member.user_id
  • user_auth (권한) — varchar2(1) — Foreign key → project_member.user_auth
  • se_no (글번호) — number — Foreign key → project_selling.se_no — NOT NULL
  • co_content (내용) — varchar2(1000)
  • co_regdate (등록일) — date