FinalProject

Tables (8)

FP_Member

  • Key (member_no) — NUMBER — Primary key — NOT NULL
  • member_id — VARCHAR2(20) — NOT NULL
  • Field (mamber_pw) — VARCHAR2(160) — NOT NULL
  • Field (member_nick) — VARCHAR2(20) — NOT NULL
  • Field2 (member_gender) — VARCHAR2(4) — NOT NULL
  • Field2 (member_birth) — DATE — NOT NULL
  • Field2 (member_phone) — VARCHAR2(20)
  • Field3 (member_email) — VARCHAR2(40) — NOT NULL
  • Field (member_joindate) — DATE — NOT NULL

Untitled (FP_hobby_category)

  • Key (hobby_category_no) — NUMBER — Primary key — NOT NULL
  • Field (hobby_name) — VARCHAR2(20) — NOT NULL

Untitled (FP_Hobby)

  • Key (hobby_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → FP_Member.Key — NOT NULL
  • Key (hobby_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (FP_BoardImage)

  • Key (image_no) — NUMBER — Primary key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
  • Field (image_url) — VARCHAR2 — NOT NULL
  • Field (image_ori) — VARCHAR2 — NOT NULL

Untitled (FP_Comment)

  • Key (comment_no) — NUMBER — Primary key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → FP_Member.Key — NOT NULL
  • Field (comment_content) — VARCHAR2(500) — NOT NULL
  • Field (comment_writedate) — DATE — NOT NULL

Untitled (FP_Recommend)

  • Key (recommend_no) — NUMBER — Primary key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → FP_Member.Key — NOT NULL
  • Field (recommend_date) — DATE — NOT NULL

Untitled (FP_MailAuth)

  • Key (mailauth_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → FP_Member.Key — NOT NULL
  • Field (mailauth_key) — VARCHAR2(100) — NOT NULL
  • Field (mailauth_complete) — VARCHAR2(4) — NOT NULL
  • Field (mailauth_date) — DATE

Untitled2 (FP_Board)

  • Key (board_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → FP_Member.Key — NOT NULL
  • Field (board_title) — VARCHAR2(400) — NOT NULL
  • Field (board_content) — VARCHAR2(4000) — NOT NULL
  • Field (board_readcount) — NUMBER — NOT NULL
  • Field (board_writedate) — DATE — NOT NULL