Achieve

Tables (6)

admin (관리자)

  • admin_id (Key) — varchar — Primary key — NOT NULL
  • password (비밀번호) — varchar
  • name (이름) — varchar

claim (Untitled)

  • bno (Key) — number — Primary key — NOT NULL
  • user_id (회원) — varchar — Foreign key → users.user_id — NOT NULL
  • title (글제목) — varchar(100)
  • content (글내용) — varchar(3000)
  • reg_date (등록일) — timestamp
  • count (조회수) — number

notice (공지사항)

  • bno (Key) — number — Primary key — NOT NULL
  • admin_id (관리자) — varchar — Foreign key → admin.admin_id — NOT NULL
  • title (글제목) — varchar(100)
  • content (글내용) — varchar(3000)
  • reg_date (등록일) — timestamp
  • count (조회수) — number

reply (댓글)

  • rno (Key) — number — Primary key — NOT NULL
  • admin_id (관리자) — varchar — Foreign key → admin.admin_id — NOT NULL
  • bno (글번호) — number — Foreign key → claim.bno — NOT NULL
  • content (댓글내용) — varchar(2000)
  • reg_date (등록일) — timestamp

reservation (예약)

  • rv_no (Key) — number — Primary key — NOT NULL
  • user_id (회원) — varchar — Foreign key → users.user_id — NOT NULL
  • rv_date (예약날짜) — varchar
  • rv_time (예약시간) — varchar
  • organization (소속) — varchar

users (회원)

  • user_id (Key) — varchar — Primary key — NOT NULL
  • password (비밀번호) — varchar
  • email (이메일) — varchar