FreeBoardProject
Tables (5)
M_Member
- Key (member_no) — number — Primary key — NOT NULL
- Field (member_id) — varchar2(20)
- Field (member_pw) — varchar2(100)
- Field (member_nickname) — varchar2(20)
- Field (member_birth) — date
- Field (member_phone) — varchar2(30)
- Field (member_email) — varchar2(100)
- Field (member_joindate) — date
Untitled (b7_board_ajs)
- Key (board_no) — number — Primary key — NOT NULL
- Key (member_no) — number — Foreign key → M_Member.Key — NOT NULL
- Field (board_title) — varchar2(100)
- Field (board_content) — varchar2(400)
- Field (board_createdate) — date
- Field (board_viewcount) — number
Untitled (b7_reply_ajs)
- Key (reply_no) — number — Primary key — NOT NULL
- Key (board_no) — number — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (reply_content) — varchar2(100)
- Field (reply_createdate) — date
Untitled (b7_thumbs)
- Key (thumb_no) — number — Primary key — NOT NULL
- Key (board_no) — number — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — number — Foreign key → Untitled.Key — NOT NULL
Untitled (b7_image_ajs)
- Key (image_no) — number — Primary key — NOT NULL
- Key (board_no) — number — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — varchar2(300)
- Field (image_filename) — varchar2(300)