돌덕(DD)
테이블 (8)
라이브방송 (BROADCAST)
- BROADCAST_SEQ (PK) — NUMBER — 기본 키 — NOT NULL — 방송번호
- BROADCAST_CASTER (FK) — VARCHAR2(1000) — 외래 키 → 회원.MEMBER_SEQ — NOT NULL — 방송인
- BROADCAST_DATE (Field) — DATE — NOT NULL — 방송날짜
- BROADCAST_TITLE (Field3) — VARCHAR2(1000) — NOT NULL — 방송제목
- BROADCAST_CONTENT (Field4) — CLOB — 방송영상 주소
마켓 (MARKET)
- MARKET_SEQ (PK) — NUMBER — 기본 키 — NOT NULL — SEQUNECE
- MARKET_ID (Key) — VARCHAR2(1000) — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
- MARKET_NUM (Field) — NUMBER — NOT NULL
- MARKET_TITLE (Field3) — VARCHAR2(200) — NOT NULL
- MARKET_CONTENT (Field4) — CLOB — NOT NULL
- MARKET_REGDATE (Field5) — NOT NULL
마켓_댓글 (MARKET_COMMENT)
- MARKET_COMMNET_SEQ (PK) — NUMBER — 기본 키 — NOT NULL
- MARKET_ID (PK2) — NUMBER — 외래 키 → 마켓.MARKET_SEQ — NOT NULL
- MARKET_COMMNET_CONTENT (Field) — CLOB — NOT NULL
- MARKET_COMMENT_REGDATE (Field2) — DATE — NOT NULL
- MARKET_NUM (Field4) — NUMBER — NOT NULL
- MARKET_ID (Field5) — VARCHAR2(1000) — NOT NULL
- MEMBER_SEQ (Key) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL — SEQUNECE
자유게시판 (FREEBOARD)
- FREEBORAD_SEQ (PK) — NUMBER — 기본 키 — NOT NULL — SEQUNECE
- FREEBORAD_ID (FK) — VARCHAR2(1000) — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
- FREEBORAD_NUM (Field) — NUMBER — NOT NULL
- FREEBORAD_TITLE (Field3) — VARCHAR2(200) — NOT NULL
- FREEBORAD_CONTENT (Field4) — CLOB — NOT NULL
- FREEBORAD_REGDATE (Field5) — DATE — NOT NULL
- FREEBORAD_LIKE (Field6) — NUMBER — NOT NULL
자유게시판_댓글 (FREEBORAD_COMMENT)
- FREEBORAD_COMMNET_SEQ (PK) — NUMBER — 기본 키 — NOT NULL — SEQUNECE
- FREEBORAD_SEQ (PK2) — NUMBER — 외래 키 → 자유게시판.FREEBORAD_SEQ — NOT NULL — SEQUNECE
- FREEBORAD_NUM (Field5) — NUMBER — NOT NULL
- FREEBORAD_ID (FK) — VARCHAR2(1000) — 외래 키 → 회원.MEMBER_SEQ — NOT NULL
- FREEBORAD_COMMENT_CONTENT (Field) — VARCHAR2(4000) — NOT NULL
- FREEBORAD_COMMENT_REGDATE (Field2) — DATE — NOT NULL
투표게시판 (VOTE)
- MEMBER_SEQ (Key) — NUMBER — 외래 키 → 회원.MEMBER_SEQ — NOT NULL — SEQUENCE
- VOTE_NAME (Field5) — VARCHAR2(1000) — NOT NULL — 스타이름
- VOTE_WEEK (Field4) — VARCHAR2(500) — NOT NULL — 투표 주차
- VOTE_ITEM (Field3) — VARCHAR2(1000) — NOT NULL — 투표항목
- VOTE_TOTAL (Field2) — NUMBER — NOT NULL — 투표수
투표결과 (VOTE_RESULT)
- VOTE_NAME (Key) — VARCHAR2(1000) — 외래 키 → 투표게시판.MEMBER_SEQ — NOT NULL — 스타이름
- VOTE_WEEK (Field) — VARCHAR2(500) — NOT NULL — 투표합산주차
- VOTE_TOTAL (Field2) — NUMBER — NOT NULL — 투표합산갯수
- VOTE_ITEM (Field3) — VARCHAR2(1000) — NOT NULL — 투표항목
회원 (MEMBER)
- MEMBER_SEQ (Key) — NUMBER — 기본 키 — NOT NULL — SEQUNECE
- MEMBER_ID (NN) — VARCHAR2(1000) — NOT NULL
- MEMBER_PW (Field2) — VARCHAR2(1000) — NOT NULL
- MEMBER_NAME (Field3) — VARCHAR2(1000) — NOT NULL
- MEMBER_PHONE (Field4) — VARCHAR2(100) — NOT NULL
- MEMBER_ADDR (Field5) — VARCHAR2(4000) — NOT NULL
- MEMBER_EMAIL (Field6) — VARCHAR2(1000) — NOT NULL
- MEMBER_REGDATE (Field7) — DATE — NOT NULL
- MEMBER_HEART (Field8) — NUMBER — NOT NULL
- MEMBER_ENABLED (Field9) — INTEGER — NOT NULL
- MEMBER_ROLE (Field10) — VARCHAR2(15) — NOT NULL
- MEMBER_VOTE (Field11) — NUMBER — NOT NULL