spring_project

Tables (5)

Admin (관리자)

  • admin_id (아이디) — varchar2 — Primary key — NOT NULL
  • admin_pwd (비번) — varchar2
  • admin_name (이름) — varchar2
  • admin_zip (우편번호) — varchar2
  • admin_addr (주소) — varchar2
  • admin_addr2 (상세주소) — varchar2
  • admin_mail_id (이메일주소) — varchar2
  • admin_mail_domain (이메일 도메인) — varchar2
  • admin_regdate (등록날짜) — timestamp
  • enabled (권한) — char

Bbs (코스 게시판)

  • bbs_no (게시판 번호) — number — Primary key — NOT NULL
  • admin_id (아이디) — varchar2 — Foreign key → Admin.admin_id — NOT NULL
  • bbs_name (글쓴이) — varchar2
  • bbs_title (제목) — varchar2
  • bbs_pwd (비밀번호) — varchar2
  • bbs_cont (내용) — clob
  • bbs_file (첨부파일명) — varchar2 — NOT NULL
  • bbs_hit (조회수) — number
  • bbs_ref (글 그룹번호) — number
  • bbs_date (등록날짜) — date

Bbs2 (인기 게시판)

  • bbs2_no (게시판 번호) — number — Primary key — NOT NULL
  • admin_id (아이디) — varchar2 — Foreign key → Admin.admin_id — NOT NULL
  • bbs2_name (글쓴이) — varchar2
  • bbs2_title (제목) — varchar2
  • bbs2_pwd (비밀번호) — varchar2
  • bbs2_cont (내용) — clob
  • bbs2_file (첨부파일명) — varchar2 — NOT NULL
  • bbs2_hit (조회수) — number
  • bbs2_ref (글 그룹번호) — number
  • bbs2_date (등록날짜) — date

Community (커뮤니티)

  • content_no (게시글 번호) — Primary key — NOT NULL
  • user_id (아이디2) — varchar2 — Foreign key → User.user_id — NOT NULL
  • content_id (유저 아이디) — varchar2
  • content_name (유저 이름) — varchar2
  • content_title (게시글 제목) — varchar2
  • content_local (지역구) — varchar2
  • content_cont (내용) — clob
  • content_file (썸네일 파일경로) — varchar2
  • content_hit (조회수) — number
  • content_ref (그룹번호) — number
  • content_step (원본구분) — number
  • content_level (댓글번호) — number
  • content_regdate (등록일자) — timestamp

User (사용자 정보)

  • user_id (아이디) — varchar2 — Primary key — NOT NULL
  • user_pwd (비번) — varchar2
  • user_name (이름) — varchar2
  • user_zip (우편번호) — varchar2
  • user_addr (주소) — varchar2
  • user_addr2 (상세주소) — varchar2
  • user_mail_id (이메일주소) — varchar2
  • user_mail_domain (이메일 도메인) — varchar2
  • user_regdate (등록날짜) — timestamp
  • user_state (가입여부) — int
  • user_delcont (탈퇴사유) — varchar2
  • user_deldate (탈퇴날짜) — date
  • enabled (권한) — char