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