ERD

Tables (6)

TBL_BOARD (Untitled3)

  • seqno — NUMBER(10) — Primary key — NOT NULL
  • userid — VARCHAR2(50) — Foreign key → TBL_MEBMER.userid
  • title — VARCHAR2(200)
  • content — CLOB
  • regdate — DATE
  • hitno — NUMBER(10)
  • likecnt — NUMBER(10)
  • writer — VARCHAR2(50)
  • dislikecnt

TBL_FILE (Untitled4)

  • fileseqno — NUMBER(10) — Primary key — NOT NULL
  • seqno — NUMBER(10)
  • org_filename — VARCHAR2(200)
  • STORED_filename — VARCHAR2(200)
  • filesize — NUMBER(10)
  • userid — VARCHAR2(50)
  • checkfile — VARCHAR2(2)

TBL_LIKE (Untitled5)

  • seqno — NUMBER(10) — Foreign key → TBL_BOARD.seqno — NOT NULL
  • userid — VARCHAR2(50) — Foreign key → TBL_MEBMER.userid
  • mylikecheck — CHAR(1)
  • mydislikecheck — CHAR(1)
  • likedate — VARCHAR2(50)
  • dislikedate — VARCHAR2(50)

TBL_MEBMER (Untitled2)

  • userid — VARCHAR2(50) — Primary key
  • username — VARCHAR2(200)
  • password — VARCHAR2(200)
  • job — VARCHAR2(20)
  • gender — VARCHAR2(20)
  • hobby — VARCHAR2(20)
  • telno — VARCHAR2(20)
  • email — VARCHAR2(20)
  • zipcode — VARCHAR2(20)
  • address — VARCHAR2(200)
  • description — VARCHAR2(2000)
  • regdate — DATE
  • lastlogindate — DATE
  • lastpwdate — DATE
  • pwcheck — NUMBER
  • role — VARCHAR2(50)
  • org_filename — VARCHAR2(50)
  • stored_filename — VARCHAR(50)
  • filesize — NUMBER
  • authkey — VARCHAR2(100)
  • lastlogoutdate — DATE

TBL_REPLY (Untitled)

  • replyseqno — NUMBER — Primary key — NOT NULL
  • userid — VARCHAR2(50) — Foreign key → TBL_MEBMER.userid
  • seqno — NUMBER(10) — Foreign key → TBL_BOARD.seqno — NOT NULL
  • replywriter — VARCHAR2(200)
  • replycontent — VARCHAR2(200)
  • replyregdate — DATE

tbl_addr (Untitled6)

  • zipcode — varchar2(10)
  • province — varchar2(50)
  • road — varchar2(200)
  • building — varchar2(200)
  • oldaddr — varchar2(200)