sharing

Tables (10)

t_board_group (Untitled5)

  • sq (Key) — Primary key — NOT NULL
  • name (Field)
  • display_index (Field2)
  • visible (Field3)

t_board_notice (Untitled6)

  • sq (Key) — Primary key — NOT NULL
  • member_sq (sq) — Foreign key → t_member.sq — NOT NULL
  • created_datetime (Field)
  • update_datetime (Field2)
  • title (Field3)
  • content (Field4)
  • view_count (Field5)
  • display_index (Field6)
  • visible (Field7)

t_board_post (Untitled3)

  • sq (Key) — Primary key — NOT NULL
  • created_datetime (Field)
  • updated_datetime (Field2)
  • title (Field3)
  • content (Field4)
  • view_count (Field6)
  • vote_count (Field7)
  • comment_count (Field8)

t_board_site (Untitled)

  • sq (Key) — Primary key — NOT NULL
  • member_sq (sq) — Foreign key → t_member.sq — NOT NULL
  • brd_group_sq (Key2) — Foreign key → t_board_group.sq — NOT NULL
  • url (Field)
  • created_datetime (Field2)
  • updated_datetime (Field3)
  • title (Field4)
  • content (Field5)
  • tagline (Field6)
  • image (Field9)
  • vote_count (Field11)
  • comment_count (Field12)
  • bookmark_count (Field13)

t_bookmark (Untitled8)

  • sq (Key) — Primary key — NOT NULL
  • member_sq (sq) — Foreign key → t_member.sq — NOT NULL
  • brd_site_sq (Key2) — Foreign key → t_board_site.sq — NOT NULL
  • register_datetime (Field)

t_claim (Untitled9)

  • sq (Key) — Primary key — NOT NULL
  • member_sq (sq) — Foreign key → t_member.sq — NOT NULL
  • target_mem_sq (sq2) — Foreign key → t_member.sq — NOT NULL
  • target_type (Field2)
  • target_sq (Field3)
  • created_datetime (Field4)
  • claim_done (Field)

t_comment (Untitled2)

  • sq (Key) — Primary key — NOT NULL
  • member_sq (sq) — Foreign key → t_member.sq — NOT NULL
  • brd_site_sq (Key2) — Foreign key → t_board_site.sq — NOT NULL
  • content (Field)
  • parent_sq (Field2)
  • order (Field3)
  • created_datetime (Field4)

t_grade (Untitled7)

  • sq (Key) — Primary key — NOT NULL
  • name (Field)
  • point (Field2)

t_member

  • sq — Primary key — NOT NULL
  • id (Field)
  • password (Field2)
  • name (Field3)
  • phone (Field4)
  • email (Field5)
  • birthday (Field6)
  • image (Field7)
  • sex (Field8)
  • nickname (Field9)
  • created_datetime (Field10)
  • updated_datetime (Field11)
  • grade_sq (Key) — Foreign key → t_grade.sq — NOT NULL
  • point (Field12)

t_vote (Untitled4)

  • sq (Key) — Primary key — NOT NULL
  • member_sq (sq) — Foreign key → t_member.sq — NOT NULL
  • brd_site_sq (Key2) — Foreign key → t_board_site.sq — NOT NULL
  • vote_type (Field)
  • created_datetime (Field2)