gang
Tables (4)
Untitled3
- no (파일번호) — number — Primary key — NOT NULL
- no (Key) — number — Foreign key → mboard.no — NOT NULL
- pic_no (사진이름) — varchar2
- origin_name (원본이름) — varchar2
chatlog (Untitled4)
- roomname (방이름) — varchar2(60) — Primary key — NOT NULL
- boardno (판매글번호) — number — Foreign key → mboard.no — NOT NULL
- writer (판매자id) — varchar2 — Foreign key → mboard.writer — NOT NULL
- req (구매자id) — varchar2 — Foreign key → member.memnum — NOT NULL
- text (채팅내용) — varchar2
- time (채팅시간) — date
- ownread (판매자확인여부) — number
- reqread (구매자확인여부) — number
- sender (채팅작성자) — varchar2
mboard (Untitled)
- no (게시판번호) — number — Primary key — NOT NULL
- writer (작성자) — varchar2 — Foreign key → member.memnum — NOT NULL
- title (제목)
- content (내용) — varchar2
- wdate (작성일자) — date
- boardk (게시판종류) — num
member (Untitled2)
- memnum (회원번호) — number — Primary key — NOT NULL
- id (아이디) — varchar2
- pass (비밀번호) — varchar2
- nick (별명) — varchar2
- kakaoid (카카오) — number
- navermail (네이버) — varchar2
- nconnect (네이버연결여부) — number
- kconnect (카카오연결여부) — number