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