20190604

Tables (5)

BOARD

  • SEQUENCE (게시글번호) — Primary key — NOT NULL
  • NOTNULL (작성자) — PK — Foreign key → MEMBER.NOTNULL — NOT NULL
  • NOTNULL (카테고리번호(1,2,3))
  • SEQUENCE (그룹번호)
  • NOTNULL (그룹순서)
  • NOTNULL (들여쓰기)
  • NOTNULL (제목)
  • NOTNULL (내용)
  • NOTNULL (작성일)
  • NOTNULL (조회수)

FESTIVAL

  • SEQUENCE (축제번호) — PK — Primary key — NOT NULL
  • NOTNULL (축제명)
  • NOTNULL (축제장소)
  • NOTNULL (시작날짜)
  • NOTNULL (종료날짜)
  • NOTNULL (내용)
  • NOTNULL (주소)
  • NOTNULL (티켓여부(Y/N))
  • NOTNULL (티켓가격)
  • (티켓이미지주소)

INTEREST

  • SEQUENCE (축제번호) — PK — Foreign key → FESTIVAL.SEQUENCE — NOT NULL
  • NOTNULL (아이디) — PK — Foreign key → MEMBER.NOTNULL — NOT NULL

MEMBER

  • NOTNULL (아이디) — PK — Primary key
  • NOTNULL (비밀번호)
  • NOTNULL (이름)
  • NOTNULL (전화번호)
  • NOTNULL (주소)
  • NOTNULL (이메일)
  • NOTNULL (가입여부)
  • NOTNULL (등급(관리자,회원))

RESERVATION

  • NOTNULL (아이디) — PK — Foreign key → MEMBER.NOTNULL — NOT NULL
  • SEQUENCE (예매번호) — PK — Foreign key → FESTIVAL.SEQUENCE — NOT NULL
  • SEQUENCE (축제번호)
  • NOTNULL (티켓수량)
  • NOTNULL (총가격)
  • NOTNULL (작성일)
  • NOTNULL (예약상태)
  • NOTNULL (취소가능여부)