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