RWM

Tables (9)

USER

  • Key (user_id) — int — Primary key — NOT NULL
  • Field (user_pw) — varchar
  • Field2 (user_name) — varchar
  • Field3 (user_address_1) — varchar
  • Field4 (user_address_2) — varchar
  • Field (user_address_3) — varchar
  • Field (profile)

Untitled (RUNNING)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → USER.Key — NOT NULL
  • Field (running_distance)
  • Field (running_duration)
  • Field (running_cal)
  • Field (running_avg_pace)
  • Field (running_min_pace)
  • Field (running_path)
  • Field (running_area_id)

Untitled (CAHTROOM)

  • Key (room_id) — int — Primary key — NOT NULL
  • Field (room_name) — varchar
  • Field (type) — int

Untitled (MESSAGE)

  • Key (m_id) — int — Primary key — NOT NULL
  • Key (room_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → USER.Key — NOT NULL
  • Field (message)
  • Field (message_regtime)

Untitled (PARTICIPANTS)

  • Key (p_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → USER.Key — NOT NULL
  • Key (room_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (FRIENDS)

  • Key (f_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → USER.Key — NOT NULL
  • Field (freind_id) — int

Untitled (BOARD)

  • Key (board_id) — int — Primary key — NOT NULL
  • Key (writer_id) — int — Foreign key → USER.Key — NOT NULL
  • Field (board_title)
  • Field (board_content)
  • Field (board_regdate)
  • Field (board_editdate)
  • Field (board_likes)

Untitled (COMMENT)

  • Key (commnet_id) — int — Primary key — NOT NULL
  • Key (comment_writer) — int — Foreign key → USER.Key — NOT NULL
  • Field (comment_title)
  • Field (comment_content)
  • Field (comment_regdate)
  • Field (comment_editdate)
  • Field (comment_order)
  • Field (comment_depth)
  • Key (commnet_parent) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (BOARD_LIKES)

  • Key (like_id) — int — Primary key — NOT NULL
  • Key (board_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → USER.Key — NOT NULL