TeamMovie

Tables (26)

BOARD

  • B_NO — NUMBER — Primary key — NOT NULL
  • B_TYPE — NUMBER — 타입
  • B_TITLE — VARCHAR2(100) — 글제목
  • B_CONTENT — CLOB — 내용
  • B_REGDATE — DATE — 작성일
  • B_HIT — NUMBER — 조회수
  • B_LIKE — NUMBER — 추천수
  • M_ID — VARCHAR2(50) — Foreign key → MEMBER.M_ID — NOT NULL — 아이디

BOARDIMG

  • BI_NO — NUMBER — Primary key — NOT NULL
  • B_NO — NUMBER — Foreign key → BOARD.B_NO — NOT NULL — 게시글번호
  • BI_IMAGE — BLOB — 이미지
  • BI_IMAGETYPE — VARCHAR2(50) — 이미지타입
  • BI_IMAGESIZE — NUMBER — 이미지크기
  • BI_IMAGENAME — VARCHAR2(100) — 이미지이름
  • BI_REGDATE — DATE — 등록일

BOARD_LIKE

  • Key (BL_NO) — NUMBER — Primary key — NOT NULL
  • B_NO — NUMBER — Foreign key → BOARD.B_NO — NOT NULL
  • M_ID — VARCHAR2(50) — Foreign key → MEMBER.M_ID — NOT NULL — 아이디;

CATEGORY

  • C_CODE — NUMBER — Primary key — NOT NULL
  • C_CATEGORY — VARCHAR2(50) — 장르

CHAT

  • C_NO — NUMBER — Primary key — NOT NULL
  • C_ROOM — STRING
  • C_CONTENT — STRING
  • C_REGDATE — DATE
  • M_ID — VARCHAR2(50) — Foreign key → MEMBER.M_ID — NOT NULL — 아이디;

COMMENT

  • CO_NO — NUMBER — Primary key — NOT NULL
  • CO_CONTENT — CLOB
  • CO_REGDATE — DATE
  • B_NO — NUMBER — Foreign key → BOARD.B_NO — NOT NULL

CONTENT

  • CT_CODE — NUMBER — Primary key — NOT NULL — 줄거리코드;
  • CT_SHOT — VARCHAR2(250) — 짧은줄거리
  • CT_LONG — CLOB — 긴줄거리

FILMRATING

  • F_CODE — NUMBER — Primary key — NOT NULL — 등급코드;
  • F_FILMRATING — VARCHAR2(50) — 등급

GPA

  • G_CODE — NUMBER — Primary key — NOT NULL — 평점
  • R_CODE — NUMBER — Foreign key → REVIEW.R_CODE — NOT NULL — 리뷰
  • G_GPA — NUMBER — 평균평점

MEMBER

  • M_ID — VARCHAR2(50) — Primary key — NOT NULL — 아이디;
  • M_PW — VARCHAR2(100) — 비밀번호
  • M_NAME — VARCHAR2(50) — 이름
  • M_EMAIL — VARCHAR2(100) — 이메일
  • M_PHONE — VARCHAR2(20) — 연락처
  • M_ROLE — VARCHAR2(10) — 권한
  • M_ADDR — VARCHAR2(100) — 주소
  • M_NICKNAME — VARCHAR2(50) — 닉네임
  • M_BIRTH — DATE — 생일
  • M_GENDER — VARCHAR2(10) — 성별
  • M_PROFILE — BLOB — 이미지(프로필)
  • M_PROFILETYPE — VARCHAR2(50) — 이미지타입
  • M_PROFILESIZE — NUMBER — 이미지크기
  • M_PROFILENAME — VARCHAR2(100) — 이미지이름
  • M_REGDATE — DATE — 가입일
  • MS_CODE — NUMBER — Foreign key → MEMBERSHIP.MS_CODE — NOT NULL — 회원등급코드

MEMBERCATEGORY

  • MC_CODE — NUMBER — Primary key — NOT NULL — 회원선호장르번호;
  • C_CODE — NUMBER — Foreign key → CATEGORY.C_CODE — NOT NULL — 장르코드
  • M_ID — VARCHAR2(50) — Foreign key → MEMBER.M_ID — NOT NULL — 아이디

MEMBERPOINT

  • MP_CODE — NUMBER — Primary key — NOT NULL — 회원포인트코드;
  • MP_STACKPOINT — NUMBER — 누적포인트
  • MP_NOWPOINT — NUMBER — 현재포인트
  • MP_USEPOINT — NUMBER — 사용포인트
  • M_ID — VARCHAR2(50) — Foreign key → MEMBER.M_ID — NOT NULL — 아이디

MEMBERSHIP

  • MS_CODE — NUMBER — Primary key — NOT NULL — 회원등급코드;
  • MS_MEMBERSHIP — VARCHAR2(20) — 회원등급

MOVIE

  • M_CODE — NUMBER — Primary key — NOT NULL — 영화코드;
  • M_TITLE — VARCHAR2(250) — 제목
  • M_RELEASE — DATE — 개봉일
  • M_DEADLINE — DATE — 마감일
  • M_GPA — NUMBER — 평점
  • M_TIME — TIMESTAMP — 상영시간
  • M_RANK — NUMBER — 순위
  • M_REGDATE — DATE — 등록일
  • N_CODE — NUMBER — Foreign key → NATION.N_CODE — NOT NULL — 국가코드
  • C_CODE — NUMBER — Foreign key → CATEGORY.C_CODE — NOT NULL — 장르코드
  • F_CODE — NUMBER — Foreign key → FILMRATING.F_CODE — NOT NULL — 등급코드
  • G_CODE — NUMBER — Foreign key → GPA.G_CODE — NOT NULL — 평점
  • M_ACTOR — VARCHAR2(250) — NOT NULL — 배우
  • M_DIRECTOR — VARCHAR2(250) — NOT NULL — 감독
  • M_LIKE — NUMBER — 영화좋아요수
  • CT_CODE — NUMBER — Foreign key → CONTENT.CT_CODE — NOT NULL — 줄거리코드

MOVIE_CATEGORY

  • MC_CODE — NUMBER — Primary key — NOT NULL
  • M_CODE — NUMBER — Foreign key → MOVIE.M_CODE — NOT NULL — 영화코드;
  • C_CODE (C_CODE2) — NUMBER — Foreign key → CATEGORY.C_CODE — NOT NULL

MOVIE_LIKE

  • ML_NO — NUMBER — Primary key — NOT NULL
  • M_CODE — NUMBER — Foreign key → MOVIE.M_CODE — NOT NULL — 영화코드;
  • M_ID — VARCHAR2(50) — Foreign key → MEMBER.M_ID — NOT NULL — 아이디;

NATION

  • N_CODE — NUMBER — Primary key — NOT NULL — 국가코드;
  • N_NATION — VARCHAR2(50) — 국가

POSTER

  • P_CODE — NUMBER — Primary key — NOT NULL — 포스터
  • M_CODE — NUMBER — Foreign key → MOVIE.M_CODE — NOT NULL — 영화코드
  • P_IMAGE — BLOB — 이미지
  • P_IMAGETYPE — VARCHAR2(50) — 이미지타입
  • P_IMAGESIZE — NUMBER — 이미지크기
  • P_IMAGENAME — VARCHAR2(100) — 이미지이름
  • P_HEAD — NUMBER — 대표이미지
  • P_REGDATE — DATE — 등록일

RECORD

  • R_CODE — NUMBER — Primary key — NOT NULL — 기록코드;
  • T_NO — NUMBER — Foreign key → TICKET.T_NO — NOT NULL — 예매번호
  • R_REGDATE — DATE — 등록일

REVIEW

  • R_CODE — NUMBER — Primary key — NOT NULL — 리뷰
  • R_CONTENT — CLOB — 리뷰
  • R_GPA — NUMBER — 평점
  • R_LIKE — NUMBER — 좋아요수
  • T_NO — NUMBER — Foreign key → TICKET.T_NO — NOT NULL — 예매번호
  • R_REGDATE — DATE — 등록일

SCHEDULE

  • S_NO — NUMBER — Primary key — NOT NULL — 스케줄번호;
  • TH_CODE — NUMBER — Foreign key → THEATER.TH_CODE — NOT NULL — 상영관
  • M_CODE — NUMBER — Foreign key → MOVIE.M_CODE — NOT NULL — 영화코드
  • S_DATE — DATE — 날짜
  • S_START — TIMESTAMP — 영화시작시간
  • S_END — TIMESTAMP — 영화종료시간
  • S_REGDATE — DATE — 등록일

THEATER

  • TH_CODE — NUMBER — Primary key — NOT NULL — 상영관
  • TH_MAXIMUM — NUMBER — 최대인원수
  • TH_PRICE — NUMBER — 가격
  • TH_STATE — NUMBER — 상영가능여부
  • TH_CONTENT — CLBO — 상영관설명
  • TH_COUNT — NUMBER — 관람인원수

TICKET

  • T_NO — NUMBER — Primary key — NOT NULL — 예매번호;
  • M_CODE — NUMBER — Foreign key → MOVIE.M_CODE — NOT NULL — 영화코드
  • M_ID — VARCHAR2(50) — Foreign key → MEMBER.M_ID — NOT NULL — 아이디
  • TH_CODE — NUMBER — Foreign key → THEATER.TH_CODE — NOT NULL — 상영관
  • T_REGDATE — DATE — 예매일
  • TS_CODE — NUMBER — Foreign key → TICKET_STATE.TS_CODE — NOT NULL — 예매상태코드

TICKET_STATE

  • TS_CODE — NUMBER — Primary key — NOT NULL — 예매상태코드;
  • TS_STATE — VARCHAR2(10) — 예매상태

VISITOR

  • V_PHONE — VARCHAR2(20) — Primary key — NOT NULL — 비회원
  • V_NAME — VARCHAR2(30) — 비회원
  • V_PW — VARCHAR2(100) — 비회원

VISITOR_TICKET

  • VT_CODE — NUMBER — Primary key — NOT NULL — 비회원
  • M_CODE — NUMBER — Foreign key → MOVIE.M_CODE — NOT NULL — 영화코드
  • TH_CODE — NUMBER — Foreign key → THEATER.TH_CODE — NOT NULL — 상영관
  • V_PHONE — VARCHAR2(20) — Foreign key → VISITOR.V_PHONE — NOT NULL — 비회원
  • VT_REGDATE — DATE — 예매일
  • TS_CODE — NUMBER — Foreign key → TICKET_STATE.TS_CODE — NOT NULL — 예매상태코드