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