7942_1

Tables (12)

BOARD (Untitled5)

  • Key — Primary key — NOT NULL
  • id (Key2) — Foreign key → BOARD_GROUP.Key — NOT NULL
  • title (Field2)
  • contents (Field3)
  • writer_id (Key3) — Foreign key → USER.Key — NOT NULL
  • writer_name (Field5)
  • hits (Field6)
  • regdate (Field7)

BOARD_GROUP (Untitled4)

  • Key — Primary key — NOT NULL
  • board_id (Field2)
  • board_name (Field3)

CATEGORY (Untitled6)

  • category_id (key) — Primary key — NOT NULL
  • c_1_Key (key2) — Foreign key → C_1.c_1_Key — NOT NULL
  • c_2_Key (key3) — Foreign key → C_2.c_2_Key — NOT NULL
  • c_3_Key (key4) — Foreign key → C_3.c_3_Key — NOT NULL

CONTENTS (Untitled11)

  • Key — Primary key — NOT NULL
  • Field

C_1 (Untitled7)

  • c_1_Key (key) — Primary key — NOT NULL
  • title (Field)
  • cotents (Field2)
  • answer (Field3)

C_2 (Untitled8)

  • c_2_Key (key) — Primary key — NOT NULL
  • title (Field)
  • cotents (Field2)
  • answer (Field3)

C_3 (Untitled9)

  • c_3_Key (key) — Primary key — NOT NULL
  • title (Field)
  • cotents (Field2)
  • answer (Field3)

GROUP_MEMBER (Untitled2)

  • Key — Primary key — NOT NULL
  • super_user (Field)
  • memberS (Field2)

MY_GROUP (Untitled10)

  • my_group_key (Key) — Primary key — NOT NULL
  • Field
  • category_id (key) — Foreign key → CATEGORY.category_id — NOT NULL

USER (Untitled3)

  • Key (PK) — Primary key — NOT NULL
  • nickname (Field3)
  • picture (Field4)
  • sex (Field5)
  • email (Field7)
  • my_group_key (Key) — Foreign key → MY_GROUP.my_group_key — NOT NULL

USER_GROUP (Table)

  • Key — Primary key — NOT NULL
  • group_id (Key3) — Foreign key → GROUP_MEMBER.Key — NOT NULL
  • user_id (Key2) — Foreign key → USER.Key — NOT NULL
  • category_id (key) — Foreign key → CATEGORY.category_id — NOT NULL

Untitled

  • Field