BEER_TB

테이블 (16)

게시글 (Post)

  • PRIMARY KEY (POST_NO) — NUMBER — 기본 키 — NOT NULL
  • FOREIGN KEY (BOARD_CODE) — VARCHAR2(20) — 외래 키 → 게시판.PRIMARY KEY — NOT NULL
  • NOT NULL (GROUP_NO) — NUMBER
  • NOT NULL (GROUP_SQ) — NUMBER
  • NOT NULL (TITLE_TAB) — NUMBER
  • NOT NULL (POST_TITLE) — VARCHAR2(50)
  • NOT NULL (POST_CONTENT) — VARCHAR2(2000)
  • NOT NULL (POST_DATE) — DATE
  • NOT NULL (POST_VIEWS) — NUMBER
  • FOREIGN KEY (USER_ID) — VARCHAR2(20) — 외래 키 → 회원.PRIMARY KEY — NOT NULL — primary key

게시판 (Main_Board)

  • PRIMARY KEY (BOARD_CODE) — VARCHAR2(20) — 기본 키 — NOT NULL
  • NOT NULL (BOARD_NAME) — VARCHAR2(30)

나라 (Origin)

  • PRIMARY KEY (ORIGIN_CODE) — VARCHAR2(20) — 기본 키 — NOT NULL
  • NOT NULL (ORIGIN_NAME) — VARCHAR2(30)

댓글 (Comment_TB)

  • PRIMARY KEY (COMMENT_NO) — NUMBER — 기본 키 — NOT NULL
  • FOREIGN KEY (POST_NO) — NUMBER — 외래 키 → 게시글.PRIMARY KEY — NOT NULL
  • FOREIGN KEY (BOARD_CODE) — VARCHAR2(20) — 외래 키 → 게시글.FOREIGN KEY — NOT NULL
  • NOT NULL (GROUP_NO) — NUMBER
  • NOT NULL (GROUP_SQ) — NUMBER
  • - (REPLY_ID) — VARCHAR(20)
  • NOT NULL (COMMENT_CONTENT) — VARCHAR2(300)
  • NOT NULL (COMMENT_DATE) — DATE
  • FOREIGN KEY (USER_ID) — VARCHAR2(20) — 외래 키 → 회원.PRIMARY KEY — NOT NULL — primary key

등급 (Grade)

  • PRIMARY KEY (GRADE_CODE) — VARCHAR2(20) — 기본 키 — NOT NULL
  • NOT NULL (GRADE_NAME) — VARCHAR2(20)

리뷰 (Review)

  • PRIMARY KEY (REVIEW_NO) — NUMBER — 기본 키 — NOT NULL
  • NOT NULL (REVIEW_CONTENT) — VARCHAR2(2000)
  • NOT NULL (REVIEW_DATE) — DATE
  • NOT NULL (REVIEW_STAR) — NUMBER
  • FOREIGN KEY (USER_ID) — VARCHAR2(20) — 외래 키 → 회원.PRIMARY KEY — NOT NULL — primary key
  • FOREIGN KEY (BEER_NO) — NUMBER — 외래 키 → 맥주.PRIMARY KEY — NOT NULL

말머리 (Category)

  • PRIMARY KEY (CATEGORY_CODE) — VARCHAR2(20) — 기본 키 — NOT NULL
  • NOT NULL (CATEGORY_NAME) — VARCHAR2(20)

맥주 (Beer)

  • PRIMARY KEY (BEER_NO) — NUMBER — 기본 키 — NOT NULL
  • NOT NULL (BEER_KOR_NAME) — VARCHAR2(100)
  • NOT NULL (BEER_ENG_NAME) — VARCHAR2(100)
  • NOT NULL (BEER_ABV) — VARCHAR2(20)
  • NOT NULL (BEER_DETAIL) — VARCHAR2(1000)
  • - (BEER_PIC) — BLOB
  • FOREIGN KEY (TYPE_CODE) — VARCHAR2(20) — 외래 키 → 종류.PRIMARY KEY — NOT NULL
  • FOREIGN KEY (ORIGIN_CODE) — VARCHAR2(20) — 외래 키 → 나라.PRIMARY KEY — NOT NULL

맥주 월드컵 (Beer_Cup)

  • PRIMARY KEY (Q_NO) — NUMBER — 기본 키 — NOT NULL
  • NOT NULL (Q_CONTENT) — VARCHAR2(300)
  • NOT NULL (Q_BEER_NAME) — VARCHAR2(100)

맥주이야기 (Beer_Story)

  • PRIMARY KEY (STORY_NO) — NUMBER — 기본 키 — NOT NULL
  • NOT NULL (STORY_NAME) — VARCHAR2(100)
  • NOT NULL (STORY_LINK) — VARCHAR2(1000)
  • NOT NULL (STORY_IMG) — VARCHAR2(1000)

모임게시판 (MOIM_Board)

  • PRIMARY KEY (MOIM_NO) — NUMBER — 기본 키 — NOT NULL
  • NOT NULL (MOIM_TITLE) — VARCHAR2(100)
  • NOT NULL (MOIM_CONTENT) — VARCHAR2(2000)
  • NOT NULL (MOIM_WRITEDATE) — DATE
  • NOT NULL (MOIM_DATE) — DATE
  • NOT NULL (MOIM_PLACE) — VARCHAR2(500)
  • FOREIGN KEY (CATEGORY_CODE) — VARCHAR2(20) — 외래 키 → 말머리.PRIMARY KEY — NOT NULL
  • FOREIGN KEY (USER_ID) — VARCHAR2(20) — 외래 키 → 회원.PRIMARY KEY — NOT NULL — primary key

모임게시판 댓글 (MOIM_Comment)

  • PRIMARY KEY (MM_NO) — NUMBER — 기본 키 — NOT NULL
  • NOT NULL (MM_CONTENT) — VARCHAR2(300)
  • NOT NULL (MM_DATE) — DATE
  • NOT NULL (GROUP_NO) — NUMBER
  • NOT NULL (GROUP_SQ) — NUMBER
  • - (REPLY_ID) — VARCHAR2(20)
  • FOREIGN KEY (USER_ID) — VARCHAR2(20) — 외래 키 → 회원.PRIMARY KEY — NOT NULL — primary key
  • PRIMARY KEY (MOIM_NO) — NUMBER — 외래 키 → 모임게시판.PRIMARY KEY — NOT NULL

북마크 (Bookmark)

  • FOREIGN KEY(COMPOSITE) (BEER_NO) — NUMBER — 외래 키 → 맥주.PRIMARY KEY — NOT NULL
  • FOREIGN KEY(COMPOSITE) (USER_ID) — VARCHAR2(20) — 외래 키 → 회원.PRIMARY KEY — NOT NULL — primary key
  • CHECK( Y/N ) (BOOKMARK_STATUS) — CHAR(1)

종류 (Type)

  • PRIMARY KEY (TYPE_CODE) — VARCHAR2(20) — 기본 키 — NOT NULL
  • NOT NULL (TYPE_NAME) — VARCHAR2(60)

채팅 (Chat)

  • PRIMARY KEY (CHATNO) — NUMBER — 기본 키 — NOT NULL
  • NOT NULL (CHATNAME) — VARCHAR2(20)
  • NOT NULL (CHATCONTENT) — VARCHAR2(100)
  • NOT NULL (CHATTIME) — DATE

회원 (User_TB)

  • PRIMARY KEY (USER_ID) — VARCHAR2(20) — 기본 키 — NOT NULL — primary key
  • NOT NULL (USER_PW) — VARCHAR2(30)
  • NOT NULL (USER_NAME) — VARCHAR2(20)
  • - (USER_EMAIL) — VARCHAR2(50)
  • - (USER_PHONE) — VARCHAR2(20)
  • - (USER_PIC) — BLOB
  • FOREIGN KEY (GRADE_CODE) — VARCHAR2(20) — 외래 키 → 등급.PRIMARY KEY — NOT NULL