mynamu

Tables (19)

daily

  • num — NUMBER — Primary key — NOT NULL — 시퀀스
  • userId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL
  • categoryNum — NUMBER — Foreign key → dailyCategory.categoryNum — NOT NULL — 시퀀스
  • subject — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • regDate — DATE — NOT NULL
  • hitCount — NUMBER — NOT NULL — DEFAULT 0
  • notice — NUMBER(1) — NOT NULL — DEFAULT 0
  • CATEGORYNUM — number — NOT NULL
  • town — VARCHAR2(100)
  • TABLENAME — VARCHAR2(100) — daily

dailyCategory

  • categoryNum — NUMBER — Primary key — NOT NULL — 시퀀스
  • categoryName — VARCHAR2(300) — NOT NULL

dailyLike

  • num — NUMBER — Foreign key → daily.num — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL

dailyReply

  • rNum — NUMBER — Primary key — NOT NULL — 시퀀스
  • num — NUMBER — Foreign key → daily.num — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL
  • content — VARCHAR2(1000) — NOT NULL
  • regDate — DATE — NOT NULL
  • answer — NUMBER — NOT NULL
  • showReply — NUMBER(1) — NOT NULL — DEFAULT 1

dailyReplyLike

  • rNum — NUMBER — Foreign key → dailyReply.rNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL
  • replyLike — NUMBER(1) — DEFAULT 1

freeBoard

  • num — NUMBER — Primary key — NOT NULL — 시퀀스
  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → togetherApply.userId — NOT NULL
  • regDate — DATE — NOT NULL
  • content — VARCHAR2(4000) — NOT NULL
  • hitCount — NUMBER — NOT NULL — DEFAULT 0

freeBoardFile

  • fileNum — NUMBER — Primary key — NOT NULL
  • num — NUMBER — Foreign key → freeBoard.num — NOT NULL — 시퀀스
  • fileName — VARCHAR2 — NOT NULL

freeBoardLike

  • num — NUMBER — Foreign key → freeBoard.num — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → togetherApply.userId — NOT NULL

freeBoardReply

  • rNum — NUMBER — Primary key — NOT NULL — 시퀀스
  • num — NUMBER — Foreign key → freeBoard.num — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → togetherApply.userId — NOT NULL
  • content — VARCHAR2(4000) — NOT NULL
  • regDate — DATE — NOT NULL
  • answer — NUMBER — NOT NULL

freeBoardReplyLike

  • rNum — NUMBER — Foreign key → freeBoardReply.rNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → togetherApply.userId — NOT NULL
  • REPLYLIKE — NUMBER(1, 0) — NOT NULL — null

member

  • memberIdx — NUMBER — Primary key — NOT NULL
  • userId — VARCHAR2(50) — NOT NULL — unique
  • nickName — VARCHAR2(100) — NOT NULL
  • userPwd — VARCHAR2(100) — NOT NULL
  • regDate — DATE — NOT NULL — default sysdate
  • modifyDate — DATE
  • secessionDate — DATE
  • loginFail — NUMBER — NOT NULL — default 0
  • lastLogin — DATE
  • post — NUMBER
  • town1 — VARCHAR2(100) — NOT NULL
  • addr — VARCHAR2(100)
  • town2 — VARCHAR2(100)
  • enabled — NUMBER — NOT NULL — defalut 1
  • membership — NUMBER — NOT NULL — defalut 10

memberDetail

  • userId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL
  • userName — VARCHAR2(30)
  • birth — DATE
  • email — VARCHAR2(100)
  • ment — VARCHAR2(300)
  • userManner — number — default 200
  • tel — VARCHAR2(30) — NOT NULL

note

  • num — NUMBER — Primary key — NOT NULL — 시퀀스
  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • senderId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL
  • receiverId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL
  • content — VARCHAR2(4000) — NOT NULL
  • sendDay — DATE — NOT NULL
  • identifyDay — DATE
  • sendDelete — VARCHAR2(1) — DEFAULT 'N'
  • receiveDelete — VARCHAR2(1) — DEFAULT 'N'

noticeBoard

  • num — NUMBER — Primary key — NOT NULL — 시퀀스
  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → togetherApply.userId — NOT NULL
  • subject — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • regDate — DATE — NOT NULL
  • hitCount — NUMBER — NOT NULL — DEFAULT 0

scrap

  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL

togetherApply

  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL
  • applyDate — DATE — NOT NULL
  • content — VARCHAR2(1000) — NOT NULL
  • acceptance — NUMBER(1) — NOT NULL

togetherCategory

  • categoryNum — NUMBER — Primary key — NOT NULL — 시퀀스
  • categoryName — VARCHAR2(1000) — NOT NULL

togetherLike

  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL

togetherList

  • tNum — NUMBER — Primary key — NOT NULL — 시퀀스
  • categoryNum — NUMBER — Foreign key → togetherCategory.categoryNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → member.memberIdx — NOT NULL
  • name — VARCHAR2(200) — NOT NULL
  • subject — VARCHAR2(200) — NOT NULL
  • regDate — DATE — NOT NULL
  • content — CLOB — NOT NULL
  • memberCnt — NUMBER — NOT NULL
  • thumbnail — VARCHAR2(255) — 이미지 파일명
  • town — VARCHAR(255)
  • HITCOUNT — NUMBER — 0
  • TABLENAME — VARCHAR2(100) — together