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)