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