돌덕(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