project
Tables (6)
Menu (액티비티 장소)
- no — varchar2(40) — Primary key — NOT NULL
- title (Key) — varchar2(500) — Primary key — NOT NULL
- menu — number
Question (질문과 답변)
- num — number — Primary key — NOT NULL
- Id — varchar2(100) — Foreign key → User.Id — NOT NULL
- title — varchar2(100)
- date — Date
- comment — varchar2(1000)
- content — varchar2(1000)
Reserve (예약 테이블)
- Id — varchar2(100) — Foreign key → User.Id — NOT NULL
- title (Key) — varchar2(500) — Foreign key → Menu.title — NOT NULL
- date — Date
- option — varchar2(100)
- count — number
- price — number
User (회원테이블)
- Id — varchar2(100) — Primary key — NOT NULL
- pwd — varchar2(60)
- name (Field) — varchar2(50)
- email — varchar2(60)
- phone — varchar2(30)
board (공지사항 및 게시판)
- num — number — Primary key — NOT NULL
- Id — varchar2(100) — Foreign key → User.Id — NOT NULL
- title — varchar2(200)
- Date — Date
- content — varchar2(1000)
gallery (갤러리)
- imagePath — varchar2(100)