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