myBoard

Tables (4)

Myile (Myfile)

  • Key (f_Idx) — number(38) — Primary key — NOT NULL
  • Field (f_Title) — varchar2(400)
  • Field (f_UUID) — varchar2(400)
  • Field (f_Path) — varchar2(200)
  • Field (f_Extn) — varchar2(50)
  • Field (f_Size) — varchar2(200)
  • b_Idx — number(38) — Foreign key → board.b_Idx — NOT NULL

board

  • b_Idx — number(38) — Primary key — NOT NULL
  • b_title (b_Title) — varchar2(500)
  • b_Cont — clob
  • b_day (b_Day) — date
  • b_count (b_Count) — number(50)
  • mem_idx (mem_Idx) — number(50) — Foreign key → member.mem_idx — NOT NULL

member

  • mem_idx (mem_Idx) — number(38) — Primary key — NOT NULL
  • mem_Nm — varchar2(100)
  • mem_Id — varchar2(100)
  • mem_Pw — varchar2(100)
  • mem_NicNm — varchar2(100)

reply

  • Key (r_Idx) — number(38) — Primary key — NOT NULL
  • Field (r_Title) — varchar2(200)
  • Field (r_Cont) — clob
  • Field (r_Day) — date
  • Field (r_Type) — number(38)
  • b_Idx — number(38) — Foreign key → board.b_Idx — NOT NULL