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 (취소가능여부)