SPACEMARKET
Tables (10)
SM_BLAHBLAH (자유게시판)
- PST_ID — VARCHAR2 — Primary key — NOT NULL
- SJ — VARCHAR2
- CN — VARCHAR2
- REPLY — NUMBER
- HITS — NUMBER
- CRTR_ID — VARCHAR2 — Foreign key → SM_USERINFO.ID — NOT NULL
- CREAT_DT — DATE
SM_BLAHBLAH_ATCH (자유게시판_첨부파일)
- ATFILE_ID — VARCHAR2 — Primary key — NOT NULL
- PST_ID — VARCHAR2 — Foreign key → SM_BLAHBLAH.PST_ID — NOT NULL
- IMG_REAL_FILE_NAME — VARCHAR2
- CRTR_ID — VARCHAR2 — Foreign key → SM_USERINFO.ID — NOT NULL
- CREAT_DT — DATE
SM_BLAHBLAH_REPLY (자유게시판_댓글)
- REPLY_ID — VARCHAR2 — Primary key — NOT NULL
- PST_ID — VARCHAR2 — Foreign key → SM_BLAHBLAH_ATCH.PST_ID — NOT NULL
- CN — VARCHAR2
- CRTR_ID — VARCHAR2 — Foreign key → SM_USERINFO.ID — NOT NULL
- CREAT_DT — DATE
- GROUP_ID — VARCHAR2
- DIVISION — NUMBER
SM_LOOKFOR (구매요청 게시판)
- PST_ID — VARCHAR2 — Primary key — NOT NULL
- SJ — VARCHAR2
- CN — VARCHAR2
- REPLY — NUMBER
- HITS — NUMBER
- CRTR_ID — VARCHAR2 — Foreign key → SM_USERINFO.ID — NOT NULL
- CREAT_DT — DATE
SM_LOOKFOR_ATCH (구매요청_첨부파일)
- ATFILE_ID — VARCHAR2 — Primary key — NOT NULL
- PST_ID — VARCHAR2 — Foreign key → SM_LOOKFOR.PST_ID — NOT NULL
- IMG_REAL_FILE_NAME — VARCHAR2
- CRTR_ID — VARCHAR2 — Foreign key → SM_USERINFO.ID — NOT NULL
- CREAT_DT — DATE
SM_LOOKFOR_REPLY (구매요청_댓글)
- REPLY_ID — VARCHAR2 — Primary key — NOT NULL
- PST_ID — VARCHAR2 — Foreign key → SM_LOOKFOR_ATCH.PST_ID — NOT NULL
- CN — VARCHAR2
- CRTR_ID — VARCHAR2 — Foreign key → SM_USERINFO.ID — NOT NULL
- CREAT_DT — DATE
- GROUP_ID — VARCHAR2
- DIVISION — NUMBER
SM_MARKET (마켓)
- PST_ID — VARCHAR2 — Primary key — NOT NULL
- SJ — VARCHAR2
- CATEGORY — VARCHAR2
- PRICE — NUMBER
- CN — VARCHAR2
- REPLY — NUMBER
- HITS — NUMBER
- CRTR_ID — VARCHAR2 — Foreign key → SM_USERINFO.ID — NOT NULL
- CREAT_DT — DATE
SM_MARKET_ATCH (마켓_첨부파일)
- ATFILE_ID — VARCHAR2 — Primary key — NOT NULL
- PST_ID — VARCHAR2 — Foreign key → SM_MARKET.PST_ID — NOT NULL
- IMG_REAL_FILE_NAME — VARCHAR2
- CRTR_ID — VARCHAR2 — Foreign key → SM_USERINFO.ID — NOT NULL
- CREAT_DT — DATE
SM_MARKET_REPLY (마켓_댓글)
- REPLY_ID — VARCHAR2 — Primary key — NOT NULL
- PST_ID — VARCHAR2 — Foreign key → SM_MARKET_ATCH.PST_ID — NOT NULL
- CN — VARCHAR2
- CRTR_ID — VARCHAR2 — Foreign key → SM_USERINFO.ID — NOT NULL
- CREAT_DT — DATE
- GROUP_ID — VARCHAR2
- DIVISION — NUMBER
SM_USERINFO (회원정보)
- ID — VARCHAR2 — Primary key — NOT NULL
- PASSWORD — VARCHAR2
- NICKNAME — VARCHAR2
- CREAT_DT — DATE
- PROFILE — VARCHAR2