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