project

Tables (3)

dochiking_board (게시글정보)

  • num (게시글번호) — primary key — Primary key — NOT NULL
  • title (제목) — VARCHAR2(200)
  • auth (작성자) — VARCHAR2(50)
  • content (글 내용) — CLOB
  • regdate (작성시간) — TimeStamp
  • visitCount (조회수) — number

dochiking_users (회원정보)

  • num (회원번호) — primarykey — Primary key — NOT NULL
  • id (아이디) — VARCHAR2(30)
  • pass (비밀번호) — VARCHAR2(30)
  • name (이름) — VARCHAR2(50)
  • nickname (닉네임) — VARCHAR2(50)
  • addr (주소) — CLOB
  • email (이메일) — VARCHAR2(100)
  • phone (전화번호) — VARCHAR2(20)
  • gender (성별) — VARCHAR2(10)

profile_image (프로필이미지)

  • img_id (이미지번호) — primary key — Primary key — NOT NULL
  • Field