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)